Microsoft Excel Shortcut Keys

Ctrl + A Selects the entire worksheet. If the worksheet contains data, and selects the current region

Ctrl + B Applies or removes bold formatting

Ctrl + C Copies the selected cells

Ctrl + D Copies the value from the cell above the active cell into the cell or the Formula Bar.

Ctrl + E Flash Fill - Automatically fills in values

Ctrl + F Displays the Find and Replace dialog box, with the Find tab selected.

Ctrl + G Displays the Go to dialog box

Ctrl + H Displays the Find and Replace dialog box, with the Replace tab selected.

Ctrl + I Applies or removes italic formatting

Ctrl + K Inserts a hyperlink

Ctrl + L Displays the Create Table dialog box

Ctrl + N Creates a new, blank workbook

Ctrl + O Displays the Open dialog box to open a file

Ctrl + P Displays the Print dialog box

Ctrl + S Save a workbook/sheet

Ctrl + T Displays the Create Table dialog box

Ctrl + U Applies or removes underlining

Ctrl + V Paste

Ctrl + W Closes the selected workbook window

Ctrl + X Cuts the selected cells

Ctrl + Y Redoes the last command or action

Ctrl + Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.