Essential Excel Shortcuts: Key Commands to Triple Your Speed From Beginner to Pro
Simply reducing the time you spend clicking with the mouse can make a big difference when a report deadline is approaching. This guide organizes essential Excel shortcuts by work routine. It includes both Windows and Mac shortcuts, along with troubleshooting tips for shortcuts that do not work.
Quick Fix (3-Minute Routine)
- Select and navigate:
Ctrl+Shift+↑↓←→ / ⌘+Shift+↑↓←→,Ctrl+Space / ⌃+Space,Shift+Space - Enter and fill:
Ctrl+Enter / ⌘+Enter,Ctrl+D / ⌘+D,Ctrl+R / ⌘+R - Format:
Ctrl+1 / ⌘+1,Ctrl(or ⌘)+Shift+$ % # @ ! ~ - Formulas:
F2 / ⌃+U,F4 / ⌘+T(Formula),Ctrl+` / ⌃+` - Data:
Ctrl+T / ⌘+T,Ctrl+Shift+L / ⌘+Shift+L,Alt+= / ⌘+Shift+T
Select and Navigate
| Task | Win | Mac | Tip |
|---|---|---|---|
| Move to edge of contiguous data | Ctrl+←/→/↑/↓ | ⌘+←/→/↑/↓ | Moves to the next blank cell |
| Select to edge of contiguous data | Ctrl+Shift+←/→/↑/↓ | ⌘+Shift+←/→/↑/↓ | For bulk tasks |
| Select current region | Ctrl+A | ⌘+A | Press twice for the entire worksheet |
| Select column/row | Ctrl+Space / Shift+Space | ⌃+Space / Shift+Space | Watch for Mac Spotlight conflicts |
| First/last cell | Ctrl+Home / Ctrl+End | Fn+⌘+← / Fn+⌘+→ | |
| Move between worksheets | Ctrl+PageUp/Down | Ctrl+PageUp/Down | Fn+Ctrl+↑/↓ alternative |
Edit and Enter Data
| Task | Win | Mac | Description |
|---|---|---|---|
| Edit cell | F2 | ⌃+U | No double-clicking required |
| Line break | Alt+Enter | ⌥+⌘+Enter | New line within a cell |
| Enter in multiple cells | Ctrl+Enter | ⌘+Enter | Applies to the entire selected range |
| Fill (down/right) | Ctrl+D / Ctrl+R | ⌘+D / ⌘+R | Copies a pattern |
| Date/time | Ctrl+; / Ctrl+Shift+; | ⌃+; / ⌃+Shift+; | Timestamp |
| Hyperlink | Ctrl+K | ⌘+K |
Formatting
| Task | Win | Mac | Description |
|---|---|---|---|
| Format Cells | Ctrl+1 | ⌘+1 | Number, alignment, and borders |
| Number format shortcuts | Ctrl(or ⌘)+Shift+$ % # @ ! ~ | Currency, percentage, date, time, comma, and General | |
| Bold/italic/underline | Ctrl+B/I/U | ⌘+B/I/U | |
| Strikethrough | Ctrl+5 | ⌘+Shift+X | |
Formulas and Auditing
| Task | Win | Mac | Description |
|---|---|---|---|
| Absolute/relative references | F4 | ⌘+T(Formula) or Fn+F4 | Cycles through $A$1 references |
| Show formulas/values | Ctrl+` | ⌃+` | For review |
| AutoSum | Alt+= | ⌘+Shift+T | Sum/average |
Data Tasks
| Task | Win | Mac | Description |
|---|---|---|---|
| Create a table | Ctrl+T | ⌘+T | Dynamic range |
| Toggle filters | Ctrl+Shift+L | ⌘+Shift+L | Include headers |
| Paste Special | Ctrl+Alt+V → V/S/T | ⌘+Ctrl+V → Select | Values, formulas, or formatting |
| Flash Fill | Ctrl+E | ⌘+E | Learns patterns |
| Remove Duplicates | Alt, A, M | Use the menu | Safer in a table |
KeyTips (Alt → Ribbon Sequences, Windows)
- AutoFit column width:
Alt, H, O, I - AutoFit row height:
Alt, H, O, A - Sort dialog box:
Alt, A, S, S - Text to Columns:
Alt, A, E - Paste Special:
Alt, H, V, S
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| ⌘+Space opens Spotlight instead of selecting a column | Mac OS shortcut takes priority | Change the Spotlight shortcut in System Settings, or use ⌃+Space in Excel |
| F keys trigger system functions | Function key settings | Mac: Use Fn+F keys or change Keyboard settings |
| Paste Special does not open | Different Alt behavior | Use the Ribbon KeyTip sequence Alt, H, V, S |
| Filters apply only partially | Header row not included in the range | Convert the range to a table (Ctrl/⌘+T) and try again |
Conclusion & Related Posts
- Preprocess Text Strings with TEXTSPLIT
- Create an Excel Drop-Down List
- Excel Conditional Formatting Guide
- Get Started with Excel PivotTables in 10 Minutes
- Practical SUMIFS and AVERAGEIFS Patterns