🔵 Easy 10 minbeginner path
Excel Keyboard Shortcuts That Actually Matter
You don't need 200 shortcuts. You need the 20 that show up hourly. Learn these and your daily Excel time drops by a third.
Learning objectives
- Memorize the 20 most-used shortcuts.
- Apply them in navigation, editing, formatting, and formulas.
Step-by-step
1. Navigation
Ctrl+Arrow (jump), Ctrl+Home/End, Ctrl+Page Down/Up (next sheet), F5 (Go To).
2. Editing
F2 (edit cell), Ctrl+D (fill down), Ctrl+R (fill right), Ctrl+; (today), Ctrl+Shift+: (now).
3. Formatting
Ctrl+1 (format dialog), Ctrl+B/I/U, Ctrl+Shift+$ (currency), Ctrl+Shift+% (percent), Ctrl+Shift+# (date).
4. Selection
Shift+Space (row), Ctrl+Space (column), Ctrl+A (region), Ctrl+Shift+Arrow (extend to edge).
5. Formulas & workbook
F4 (toggle reference), F9 (evaluate selection), Alt+= (autosum), Ctrl+T (Table), Ctrl+S (save).
Key takeaways
- Memorize the 20 most-used shortcuts.
- Apply them in navigation, editing, formatting, and formulas.
Related lessons
Excel Basics: The Ribbon, Cells, and Saving
12 min • Beginner
Your First Formulas: SUM, AVERAGE, and Basic Math
15 min • Easy
Lookups: VLOOKUP and XLOOKUP Explained
20 min • Intermediate
Pivot Tables in Under 20 Minutes
20 min • Advanced