Cheat sheet

Shortcuts that actually pay back the time you spent learning them

Skipping the giant alphabetical list — these are the shortcuts that show up in real workflows: navigation, selection, editing, and formulas. Side-by-side for Windows and Mac.

Navigation

Action	Windows	Mac
Jump to edge of data region	`Ctrl`+`Arrow`	`⌘`+`Arrow`
Go to cell A1	`Ctrl`+`Home`	`Fn`+`Ctrl`+`←`
Go to last used cell	`Ctrl`+`End`	`Fn`+`Ctrl`+`→`
Switch worksheets	`Ctrl`+`PgUp` / `PgDn`	`⌥`+`←` / `→`
Open Go To dialog	`Ctrl`+`G`	`⌃`+`G`

Selection

Action	Windows	Mac
Select to edge of data	`Ctrl`+`Shift`+`Arrow`	`⌘`+`Shift`+`Arrow`
Select entire column	`Ctrl`+`Space`	`⌃`+`Space`
Select entire row	`Shift`+`Space`	`Shift`+`Space`
Select current region	`Ctrl`+`A`	`⌘`+`A`
Extend selection by one screen	`Shift`+`PgDn`	`Shift`+`Fn`+`↓`

Editing & data

Action	Windows	Mac
Edit current cell	`F2`	`⌃`+`U`
Fill down	`Ctrl`+`D`	`⌘`+`D`
Fill right	`Ctrl`+`R`	`⌘`+`R`
Insert today's date	`Ctrl`+`;`	`⌃`+`;`
Insert current time	`Ctrl`+`Shift`+`:`	`⌘`+`;`
Paste Special dialog	`Ctrl`+`Alt`+`V`	`⌘`+`⌃`+`V`
Toggle absolute / relative reference	`F4`	`⌘`+`T`
Insert / delete row	`Ctrl`+`+` / `Ctrl`+`-`	`⌘`+`Shift`+`=` / `⌘`+`-`

Formulas

Action	Windows	Mac
Start a SUM	`Alt`+`=`	`⌘`+`Shift`+`T`
Show all formulas (toggle)	`Ctrl`+`	`⌃`+`
Recalculate everything	`F9`	`Fn`+`F9`
Recalculate active sheet only	`Shift`+`F9`	`Shift`+`Fn`+`F9`
Insert function dialog	`Shift`+`F3`	`Shift`+`Fn`+`F3`
Confirm as array formula (legacy)	`Ctrl`+`Shift`+`Enter`	`⌃`+`Shift`+`Return`

Formatting

Action	Windows	Mac
Format Cells dialog	`Ctrl`+`1`	`⌘`+`1`
Apply number format	`Ctrl`+`Shift`+`1`	`⌃`+`Shift`+`1`
Apply percentage format	`Ctrl`+`Shift`+`5`	`⌃`+`Shift`+`5`
Apply currency format	`Ctrl`+`Shift`+`4`	`⌃`+`Shift`+`4`
Apply date format	`Ctrl`+`Shift`+`3`	`⌃`+`Shift`+`3`

If you only learn five

The five shortcuts most worth memorizing

Ctrl+Shift+Arrow — select to the edge of your data, every time. Replaces every "drag to row 5000" workflow.
Alt+= — start a SUM with the range pre-filled.
F4 — toggle $ on the reference under the cursor while editing a formula.
Ctrl+; — insert today's date as a static value (not a volatile TODAY()).
Ctrl+T — convert a range to a Table. Self-expanding references and structured names follow for free.