Essentials
| Action | Windows | Mac |
|---|---|---|
| Copy | Ctrl + C | ⌘ + C |
| Cut | Ctrl + X | ⌘ + X |
| Paste | Ctrl + V | ⌘ + V |
| Paste Special | Ctrl + Alt + V | ⌃ + ⌘ + V |
| Undo | Ctrl + Z | ⌘ + Z |
| Redo | Ctrl + Y | ⌘ + Y |
| Save | Ctrl + S | ⌘ + S |
| Find | Ctrl + F | ⌘ + F |
| Select everything | Ctrl + A | ⌘ + A |
Moving around
| Action | Windows | Mac |
|---|---|---|
| Jump to the edge of the data | Ctrl + arrow key | ⌘ + arrow key |
| Go to cell A1 | Ctrl + Home | fn + ⌃ + ← |
| Go to the last used cell | Ctrl + End | fn + ⌃ + → |
Selecting
| Action | Windows | Mac |
|---|---|---|
| Select to the edge of the data | Ctrl + Shift + arrow key | ⌘ + Shift + arrow key |
| Select the whole column | Ctrl + Space | ⌃ + Space |
| Select the whole row | Shift + Space | Shift + Space |
Editing and formulas
| Action | Windows | Mac |
|---|---|---|
| Edit the active cell | F2 | ⌃ + U |
| Fill down | Ctrl + D | ⌘ + D |
| Fill right | Ctrl + R | ⌘ + R |
| AutoSum | Alt + = | ⌘ + Shift + T |
| Toggle absolute reference ($A$1) | F4 | ⌘ + T |
| New line inside a cell | Alt + Enter | ⌥ + Return |
| Insert today's date | Ctrl + ; | ⌃ + ; |
| Show formulas instead of results | Ctrl + ` | ⌃ + ` |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B | ⌘ + B |
| Italic | Ctrl + I | ⌘ + I |
| Underline | Ctrl + U | ⌘ + U |
| Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Currency format | Ctrl + Shift + $ | ⌃ + Shift + $ |
| Percent format | Ctrl + Shift + % | ⌃ + Shift + % |
Data
| Action | Windows | Mac |
|---|---|---|
| Turn filters on or off | Ctrl + Shift + L | ⌘ + Shift + F |
| Create a table | Ctrl + T | ⌃ + T |
Mac shortcuts are for Excel for Mac. On some Mac keyboards you need fn for F-keys. ⌘ is Command, ⌃ is Control and ⌥ is Option.
Practice: 30-second shortcut drill
Knowing a shortcut isn't the same as using it without thinking. Click the box and press each shortcut as fast as you can.
Press the shortcut for:
The five that matter most in an Excel test
- F4 (Mac: ⌘ + T) while typing a formula: locks a reference as $A$1, the most common test trap.
- Ctrl + D (Mac: ⌘ + D): copies a formula down a selected column in one go.
- Ctrl + Shift + arrow (Mac: ⌘ + Shift + arrow): selects a whole range instantly for SUM, SUMIFS or a lookup.
- Alt + = (Mac: ⌘ + Shift + T): AutoSum.
- Ctrl + Z (Mac: ⌘ + Z): because under time pressure, you will need it.
Test more than shortcuts
The free 10-minute test checks formulas, references, lookups and more.
Frequently asked questions
What are the most useful Excel shortcuts?
Copy, paste and undo, then F4 to lock references, Ctrl + D to fill down, Ctrl + Shift + arrow to select data, and Alt + = for AutoSum. Those save the most time day to day.
Do Excel shortcuts work on a Mac?
Most do, with ⌘ (Command) in place of Ctrl. A few are different, such as AutoSum (⌘ + Shift + T) and editing a cell (⌃ + U). The table lists both.
Can I print this Excel shortcuts cheat sheet?
Yes: use the Print button at the top. The page prints as clean tables without the menus and the drill.
Do Excel tests check shortcuts?
Some do directly, but mostly shortcuts matter because tests are timed. Fast selection and filling leave more time for the hard tasks.