The complete Microsoft Excel keyboard shortcut reference — files, navigation, selection, data entry, formulas, formatting, rows & columns, and data tools for Windows and Mac.
77 shortcutsWindowsmacOS
📗
Microsoft Excel — Keyboard Shortcuts
Windows · Shortcuts Hub
Workbook & Files
New workbookCtrl+N
OpenCtrl+O
SaveCtrl+S
Save AsF12
PrintCtrl+P
Close workbookCtrl+W
Undo / redoCtrl+Z/Ctrl+Y
Navigation
Move one cell (any direction)Arrow+keys
Move to edge of data regionCtrl+Arrow
Go to cell A1Ctrl+Home
Go to last used cellCtrl+End
Move to start of rowHome
Screen up / downPgUp/PgDn
Next / previous worksheetCtrl+PgDn/PgUp
Open Go To dialogCtrl+G/F5
Toggle end modeEnd
Selection
Extend selection one cellShift+Arrow
Extend selection to data edgeCtrl+Shift+Arrow
Select entire columnCtrl+Space
Select entire rowShift+Space
Select current regionCtrl+A
Extend selection to A1 / last cellCtrl+Shift+Home/End
Add non-adjacent cells to selectionCtrl+Click
Select visible cells onlyAlt+;
Entering & Editing Data
Edit active cellF2
Confirm entry / move downEnter
Confirm & move rightTab
Cancel entryEsc
Start a new line in cellAlt+Enter
Fill down / rightCtrl+D/Ctrl+R
Fill selection with entry (all cells)Ctrl+Enter
Insert current dateCtrl+;
Insert current timeCtrl+Shift+;
Copy value from cell aboveCtrl+'+(or+Ctrl+Shift+")
Repeat last actionF4/Ctrl+Y
Delete cell contentsDel
Flash FillCtrl+E
Copy, Paste & Insert
Copy / Cut / PasteCtrl+C/X/V
Paste SpecialCtrl+Alt+V
Insert cells / rows / columnsCtrl+Shift++
Delete cells / rows / columnsCtrl+-
Insert a new worksheetShift+F11
Hide / unhide columnsCtrl+0/Ctrl+Shift+0
Hide / unhide rowsCtrl+9/Ctrl+Shift+9
Group / ungroup rows or columnsAlt+Shift+→/←
Formulas & Functions
Start a formula=
AutoSumAlt+=
Insert function dialogShift+F3
Toggle absolute / relative referenceF4
Enter as array formulaCtrl+Shift+Enter
Calculate all workbooksF9
Calculate active sheetShift+F9
Toggle show formulasCtrl+`
Expand / collapse formula barCtrl+Shift+U
Insert function argument namesCtrl+Shift+A
Formatting
Format Cells dialogCtrl+1
Bold / Italic / UnderlineCtrl+B/I/U
StrikethroughCtrl+5
Apply general number formatCtrl+Shift+~
Apply number format (2 dp)Ctrl+Shift+1
Apply currency formatCtrl+Shift+4
Apply percentage formatCtrl+Shift+5
Apply date formatCtrl+Shift+3
Apply time formatCtrl+Shift+2
Add outline borderCtrl+Shift+7
Remove bordersCtrl+Shift+-
Create tableCtrl+T
Data & Views
Filter (toggle AutoFilter)Ctrl+Shift+L
Open filter dropdownAlt+↓+(on+header)
Insert chart (default)Alt+F1
Insert chart on new sheetF11
Open Name ManagerCtrl+F3
FindCtrl+F
ReplaceCtrl+H
Spell checkF7
Insert comment / noteShift+F2
Open Visual Basic EditorAlt+F11
Generated from shortcuts.growwithloki.com · Microsoft Excel cheat sheet