Keyboard Shortcuts

Essential Excel keyboard shortcuts for faster navigation, formula entry, formatting, and analysis. Memorizing these shortcuts is one of the highest-ROI investments in Excel productivity.

Syntax

excel-mastery

Ctrl+T: Convert to Table
Ctrl+Shift+L: Toggle AutoFilter
F4: Toggle absolute/relative reference
Alt+=: AutoSum
Ctrl+`: Show/hide formulas

Example

excel-mastery

Ctrl+T — Convert range to Table
Alt+= — AutoSum selected range
F4 — Toggle $A$1 / A$1 / $A1 / A1
Ctrl+` — Show formula text in cells
Ctrl+; — Insert today's date
F2 — Enter cell edit mode
F9 — Recalculate workbook
Alt+N+V — Insert Pivot Table
Ctrl+Shift+~ — General number format
Ctrl+1 — Open Format Cells dialog