Are you looking for complete list of Microsoft Excel shortcuts?
Here is the complete list of Excel shortcuts for you. The list comprises the all the shortcuts for Excel 2003 and Excel 2007.
Some most important and frequently used Excel shortcuts are listed here in below table while we are also attaching complete list in xls format for your free download. This comprehensive list is one of the extremely useful tools for Excel users.
You can keep in handy and start learning few shortcuts a day. Then practice those during your day to day operation. This way very soon all most used Excel shortcuts will be on your tips.
It is also a good practice to make a one page list of most needed Excel shortcuts, take a printout and stick it in front of you on your desk. This will be super easy for you to quickly have a glimpse on these shortcuts while working on MS Excel.
For example here is the sample of one pager list:
Action | Excel Shortcut |
Close a workbook | Ctrl+W |
Open a workbook | Ctrl+O |
Go to the Home tab | Alt+H |
Save a workbook | Ctrl+S |
Cut | Ctrl+X |
Copy | Ctrl+C |
Paste | Ctrl+V |
Undo | Ctrl+Z |
Bold | Ctrl+B |
Remove cell contents | Delete key |
Choose a fill color | Alt+H, H |
Go to Insert tab | Alt+N |
Delete column | Alt+H,D, then C |
Center align cell contents | Alt+H, A, then C |
Go to Page Layout tab | Alt+P |
Go to Data tab | Alt+A |
Go to View tab | Alt+W |
Open context menu | Shift+F10, or Context key |
Add borders | Alt+H, B |
Go to Formula tab | Alt+M |
Hide the selected rows | Ctrl+9 |
Hide the selected columns | Ctrl+0 |
We hope you will find this post useful for your daily work. As promised above get the xls file from here Excel Shortcuts.xls