The Most Useful Excel Keyboard Shortcuts
Key Description
Ctrl + Z Undo
Ctrl + C Copy
Ctrl + C and then Enter Paste
Ctrl + V Multiple Paste
Ctrl + X Cut
Ctrl + F or Shift + F5 Find
Ctrl + H Find & Replace
Ctrl + G or F5 Go To
Ctrl + P Print
Ctrl + O Open
Ctrl + N Creates a new blank file
Ctrl + S Save
Ctrl + W Close workbook
Ctrl + F4 Close
Alt + F4 Close Excel
F9 Calculate all sheets in all open workbooks
Shift + F9 Calculate the active worksheet
Ctrl + Alt + F9 Calculate all sheets in the active workbook
Ctrl + Arrow or End and then press Arrow Move to edge of region
Ctrl + * Select current region
Ctrl + A Select entire region or worksheet (press twice for worksheet)
Ctrl + Home Select A1
Ctrl + End Select last cell in range
Ctrl + Shift + End Select from active cell to last cell in range
Ctrl + Shift + Home Select from active cell to A1
Ctrl + Page Down Move to next worksheet
Ctrl + Page Up Move to previous worksheet
Ctrl + Tab Move to next open workbook
Ctrl + N Open new workbook
Shift + F11 Insert new worksheet
Alt + F11 Open VBE
Ctrl + Shift + Enter Array formula
Ctrl + F3 Define name
Ctrl + Space Selects the current columns
Shift + Space Selects the current rows
Ctrl + 9 Hides the selected rows
Ctrl + 0 Hides the selected columns
Ctrl + ( Display hidden rows
Ctrl + ) Display hidden columns
Ctrl + - Deletes rows, columns or cells
Ctrl + + Inserts rows, columns or cells
Ctrl + ` Toggles between displaying cell values or formulas in the worksheet
Ctrl + K Insert Hyperlink or Edit hyperlink
Ctrl + L Displays the Create List dialog box
Ctrl + 1 Format cells
Ctrl + : Enters the current time
Ctrl + ; Enters the current date