microsoft excel shortcuts

Complete List of Microsoft Excel Shortcuts (Downloadable file inside)

by

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

Have a look on How to Use VLOOK UP in MS Excel.

Leave a Comment