Excel Keyboard Shortcuts
74 essential shortcuts to work faster in Excel. Master these and save hours every week.
Navigation
9 shortcuts
Go to cell A1Ctrl + Home
Go to last used cell in the sheetCtrl + End
Jump to the edge of data in a directionCtrl + Arrow
Open the Go To dialogCtrl + G
Switch to the previous sheet tabCtrl + Page Up
Switch to the next sheet tabCtrl + Page Down
Move to the next cell to the rightTab
Move to the previous cell to the leftShift + Tab
Scroll to show the active cellCtrl + Backspace
Selection
8 shortcuts
Select to the edge of data in a directionCtrl + Shift + Arrow
Select from current cell to the last used cellCtrl + Shift + End
Select from current cell to A1Ctrl + Shift + Home
Select the entire columnCtrl + Space
Select the entire rowShift + Space
Select the entire worksheet (or current data region)Ctrl + A
Extend selection by one cellShift + Arrow
Toggle AutoFilter on/offCtrl + Shift + L
Editing
12 shortcuts
Edit the active cell (enter edit mode)F2
Cancel editing in a cellEscape
Confirm cell entry and move downEnter
Undo last actionCtrl + Z
Redo last undone actionCtrl + Y
Clear cell contentsDelete
Fill down (copy cell above)Ctrl + D
Fill right (copy cell to the left)Ctrl + R
Insert today's dateCtrl + ;
Insert current timeCtrl + Shift + ;
Fill all selected cells with the current entryCtrl + Enter
Start a new line within the same cellAlt + Enter
Copy & Paste
5 shortcuts
Copy selected cellsCtrl + C
Cut selected cellsCtrl + X
PasteCtrl + V
Paste Special dialogCtrl + Shift + V
Paste Special (alternative)Ctrl + Alt + V
Formatting
10 shortcuts
Toggle boldCtrl + B
Toggle italicCtrl + I
Toggle underlineCtrl + U
Open Format Cells dialogCtrl + 1
Apply currency formatCtrl + Shift + $
Apply percentage formatCtrl + Shift + %
Apply date format (DD-MMM-YY)Ctrl + Shift + #
Apply general number formatCtrl + Shift + ~
Apply number format with 2 decimalsCtrl + Shift + !
Auto-fit column widthAlt + H + O + I
Formulas
10 shortcuts
Start a formula=
AutoSum the selected rangeAlt + =
Toggle absolute/relative reference ($) while editingF4
Show/hide all formulas in the sheetCtrl + `
Enter as an array formula (legacy CSE)Ctrl + Shift + Enter
Copy formula from the cell aboveCtrl + '
Open the Insert Function dialogShift + F3
Calculate all open workbooksF9
Calculate the active sheet onlyShift + F9
Select cells referenced by the current formulaCtrl + [
Rows, Columns & Sheets
10 shortcuts
Insert cells, rows, or columnsCtrl + +
Delete cells, rows, or columnsCtrl + -
Insert a new worksheetCtrl + Shift + +
Rename the current sheet tabAlt + H + O + R
Hide selected rowsCtrl + 9
Unhide selected rowsCtrl + Shift + 9
Hide selected columnsCtrl + 0
Unhide selected columnsCtrl + Shift + 0
Group selected rows or columnsAlt + Shift + Right
Ungroup selected rows or columnsAlt + Shift + Left
Find & Replace
3 shortcuts
Open Find dialogCtrl + F
Open Find and Replace dialogCtrl + H
Find with formatting optionsCtrl + Shift + F
Workbook & File
7 shortcuts
Create a new workbookCtrl + N
Open an existing workbookCtrl + O
Save the current workbookCtrl + S
Close the current workbookCtrl + W
Print the current sheetCtrl + P
Save As (choose location and format)F12
Close ExcelCtrl + F4