Top 5 Excel keyboard shortcuts

Here are some pretty nifty keyboard shortcuts for Excel that even I, a self-professed Excel nerd, did not know of.

(taken from HP's Top 9 Excel formatting keyboard shortcuts)

• CTRL + 1
Very handy. Displays the Format Cells dialogue box, which includes all of your formatting options.

• ALT + F1
This is quite possibly the most useful feature of Excel. It creates a chart of the selected data.

• CTRL + F2
Displays the Print Preview window so you know how your document would look on paper.

• CTRL + K
Displays the Hyperlink dialogue box for new or existing hyperlinks. Clicking hyperlinks in Excel can link to a website, open a separate specified file, open a compose e-mail window, or take you to a spot in the document you’re working in.

• CTRL + SHIFT + &
Applies the outline border to the selected cell, which can make your spreadsheet easier to read and look more professional.


More keyboard shortcuts for Excel available here.


Follow me on Twitter and Tumblr