Excel shortcuts
The shortcuts that save the most time on a timed test. Our practice grid follows Windows Excel, so the Windows column is what you will press in lessons. Mac keys are for Excel for Mac.
Moving and selecting
| Action | Windows | Mac |
|---|---|---|
| Jump to the edge of the data | Ctrl+Arrow | Cmd+Arrow |
| Select to the edge of the data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Select the current region or whole sheet | Ctrl+A | Cmd+A |
| Select the entire column | Ctrl+Space | Ctrl+Space |
| Select the entire row | Shift+Space | Shift+Space |
| Go to A1 | Ctrl+Home | Ctrl+Home (fn+Ctrl+Left) |
| Go to a cell or range | Ctrl+G or F5 | Ctrl+G |
Editing
| Action | Windows | Mac |
|---|---|---|
| Edit the active cell | F2 | Ctrl+U |
| Fill down | Ctrl+D | Ctrl+D |
| Fill right | Ctrl+R | Ctrl+R |
| New line inside a cell | Alt+Enter | Option+Return |
| Enter today's date | Ctrl+; | Ctrl+; |
| Undo / redo | Ctrl+Z / Ctrl+Y | Cmd+Z / Cmd+Y |
| Find / replace | Ctrl+F / Ctrl+H | Cmd+F / Ctrl+H |
Formulas
| Action | Windows | Mac |
|---|---|---|
| AutoSum | Alt+= | Cmd+Shift+T |
| Cycle relative and absolute references | F4 | Cmd+T |
| Show formulas instead of values | Ctrl+` | Ctrl+` |
| Recalculate all | F9 | F9 |
Formatting and data
| Action | Windows | Mac |
|---|---|---|
| Format Cells dialog | Ctrl+1 | Cmd+1 |
| Bold | Ctrl+B | Cmd+B |
| Create a table | Ctrl+T | Ctrl+T |
| Turn filters on or off | Ctrl+Shift+L | Cmd+Shift+F |