Excel Shortcuts Cheat Sheet (Windows + Mac, 2026)
If you live in Excel, shortcuts are the single biggest speed upgrade you can make. This cheat sheet covers the 80 keystrokes that real power users hit every day, on both Windows and Mac.
Navigation
- Ctrl + ↑ ↓ ← → → jump to edge of data
- Ctrl + Home → go to A1
- Ctrl + End → last used cell
- Ctrl + Page Up / Page Down → previous / next sheet
- Ctrl + G → Go To
- Ctrl + F → Find
- Ctrl + H → Find & Replace
Selection
- Ctrl + Shift + ↑ ↓ ← → → select to edge
- Ctrl + Space → select column
- Shift + Space → select row
- Ctrl + A → select all
- Ctrl + Shift + L → toggle filter
Editing
- F2 → edit active cell
- Alt + Enter → new line inside a cell
- Ctrl + D → fill down
- Ctrl + R → fill right
- Ctrl + Z / Ctrl + Y → undo / redo
- Ctrl + ; → insert today's date
- Ctrl + Shift + ; → insert current time
- Ctrl + Enter → fill selection with the same value
Formatting
- Ctrl + B / I / U → bold / italic / underline
- Ctrl + 1 → Format Cells dialog
- Ctrl + Shift + $ → currency
- Ctrl + Shift + % → percent
- Ctrl + Shift + # → date format
- Alt + H + H → fill color (Windows ribbon)
- Ctrl + Shift + & → add border
- Ctrl + Shift + _ → remove border
Formulas
- = → start a formula
- F4 → toggle absolute / relative reference ($A$1 ↔ A1)
- Alt + = → AutoSum
- F9 → recalculate
- Ctrl + ` → show all formulas
- Ctrl + [ → trace precedents
- Ctrl + ] → trace dependents
Rows, columns, sheets
- Ctrl + + → insert row/column
- Ctrl + - → delete row/column
- Shift + F11 → new sheet
- Ctrl + 9 / Ctrl + 0 → hide row / column
- Ctrl + Shift + 9 / 0 → unhide row / column
Pivot tables & tables
- Ctrl + T → create table
- Alt + N + V → new pivot table (Windows)
- Alt + J + T + A → refresh pivot
Mac equivalents
On Mac, replace Ctrl with ⌘ (Command) for most shortcuts. A few exceptions: F4 absolute reference is fn + F4 or ⌘ + T; format cells is ⌘ + 1; insert row is ⌃ + I.