Work faster
Excel Keyboard Shortcut Deck
63 practical Windows-oriented shortcuts grouped by task. Some shortcuts vary by Excel version, operating system and keyboard layout.
Navigation 8Selection 7Editing 11Clipboard 4Formatting 9Formulas 8Rows, columns & sheets 8Find & workbook 8
Selection
Ctrl + Shift + ArrowExtend selection to the edge of data
Ctrl + Shift + EndSelect to last used cell
Ctrl + Shift + HomeSelect back to A1
Ctrl + SpaceSelect entire column
Shift + SpaceSelect entire row
Ctrl + ASelect current region / sheet
Shift + ArrowExtend selection one cell
Editing
F2Edit active cell
EscCancel current entry
Ctrl + ZUndo
Ctrl + YRedo
DeleteClear selected contents
Ctrl + DFill down
Ctrl + RFill right
Ctrl + EnterFill all selected cells with current entry
Alt + EnterNew line inside a cell
Ctrl + ;Insert current date
Ctrl + Shift + ;Insert current time
Clipboard
Ctrl + CCopy
Ctrl + XCut
Ctrl + VPaste
Ctrl + Alt + VOpen Paste Special
Formatting
Ctrl + BBold
Ctrl + IItalic
Ctrl + UUnderline
Ctrl + 1Open Format Cells
Ctrl + Shift + $Currency number format
Ctrl + Shift + %Percentage format
Ctrl + Shift + #Date format
Ctrl + Shift + !Number format with decimals
Alt + H, O, IAutoFit column width
Formulas
=Start a formula
Alt + =AutoSum
F4Toggle absolute / relative reference while editing
Ctrl + `Show or hide formulas
Shift + F3Insert Function dialog
F9Calculate open workbooks
Shift + F9Calculate active worksheet
Ctrl + [Select directly referenced cells
Rows, columns & sheets
Ctrl + +Insert cells, rows or columns
Ctrl + -Delete cells, rows or columns
Ctrl + Shift + +Insert a worksheet in many Windows setups
Ctrl + 9Hide selected rows
Ctrl + Shift + 9Unhide rows
Ctrl + 0Hide selected columns
Ctrl + Shift + 0Unhide columns where supported
Alt + H, O, RRename current sheet
Find & workbook
Ctrl + FFind
Ctrl + HFind and replace
Ctrl + NNew workbook
Ctrl + OOpen workbook
Ctrl + SSave
Ctrl + WClose workbook
Ctrl + PPrint
F12Save As in desktop Excel
Shortcut note: Excel for macOS uses different modifier keys for many commands. This deck is intentionally labeled Windows-oriented rather than presenting unverified one-to-one Mac equivalents.