X

Excel Keyboard Shortcuts 43 shortcuts · Windows & macOS · Last updated Nov 2026

Mouse-free Excel is 10x faster. This cheat sheet collects the shortcuts spreadsheet pros rely on daily — jumping across data, selecting ranges, formatting numbers and editing formulas — with Windows and macOS keys side by side.

Action Windows macOS
Jump to edge of data region CtrlArrow CmdArrow
Go to cell A1 CtrlHome CmdHome
Go to last used cell CtrlEnd CmdEnd
Go To dialog CtrlG CtrlG
Find CtrlF CmdF
Next / previous worksheet CtrlPagethenDownorCtrlPagethenUp CmdPagethenDownorCmdPagethenUp
Go to start of row Home FnLeft

Selection5

Action Windows macOS
Select to edge of data region CtrlShiftArrow CmdShiftArrow
Select all cells CtrlA CmdA
Extend selection by one cell ShiftArrow ShiftArrow
Select entire column CtrlSpace CtrlSpace
Select entire row ShiftSpace ShiftSpace

Editing9

Action Windows macOS
Edit active cell F2 CtrlU
New line inside a cell AltEnter OptionReturn
Fill selected cells with entry CtrlEnter CmdReturn
Fill down from cell above CtrlD CmdD
Fill right from cell left CtrlR CmdR
Paste Special dialog CtrlAltV CmdCtrlV
Undo / redo CtrlZorCtrlY CmdZorCmdY
Cancel entry / exit edit mode Esc Esc
Insert current date / time Ctrl;orCtrlShift; Ctrl;orCtrlShift;

Formatting8

Action Windows macOS
Bold / italic / underline CtrlBorCtrlIorCtrlU CmdBorCmdIorCmdU
Open Format Cells dialog Ctrl1 Cmd1
Apply number format (two decimals) CtrlShift1 CtrlShift1
Apply time format CtrlShift2 CtrlShift2
Apply date format CtrlShift3 CtrlShift3
Apply currency format CtrlShift4 CtrlShift4
Apply percentage format CtrlShift5 CtrlShift5
Apply outline border CtrlShift7 CmdOption0

Formulas & Functions5

Action Windows macOS
Toggle absolute / relative references F4 CmdT
Recalculate all worksheets F9 FnF9
Recalculate active worksheet ShiftF9 ShiftFnF9
Show / hide formulas Ctrl` Cmd`
AutoSum Alt= CmdShiftT

Rows & Columns4

Action Windows macOS
Hide selected rows Ctrl9 Cmd9
Unhide selected rows CtrlShift9 CmdShift9
Delete selected cells / rows Ctrl- Ctrl-
Group selected rows / columns ShiftAltRight CmdShiftK

Workbook5

Action Windows macOS
New / open workbook CtrlNorCtrlO CmdNorCmdO
Save / Save As CtrlSorF12 CmdSorCmdShiftS
Print CtrlP CmdP
Close workbook CtrlW CmdW
Insert new worksheet ShiftF11 ShiftF11

Related Cheat Sheets

More in popular software · 6 sheets