Excel shortcuts
If you leave the mouse alone, you work noticeably faster. Start with three or four combinations from this list and add one every week.
Practise for free on your own keyboardTake the shortcuts test
Moving around your sheet
| What | Windows | Mac |
|---|---|---|
| Jump to the end of your list | Ctrl + arrow | Cmd + arrow |
| Back to the first cell | Ctrl + Home | Ctrl + Home |
| To the last cell you've used | Ctrl + End | Ctrl + End |
| Next worksheet | Ctrl + Page Down | Fn + Ctrl + down arrow |
Selecting cells
| What | Windows | Mac |
|---|---|---|
| Extend the selection one cell at a time | Shift + arrow | Shift + arrow |
| Select everything to the end of your list | Ctrl + Shift + arrow | Cmd + Shift + arrow |
| A whole column | Ctrl + Space | Ctrl + Space |
| A whole row | Shift + Space | Shift + Space |
| The whole sheet | Ctrl + A | Cmd + A |
Editing
| What | Windows | Mac |
|---|---|---|
| Copy | Ctrl + C | Cmd + C |
| Cut | Ctrl + X | Cmd + X |
| Paste | Ctrl + V | Cmd + V |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y | Cmd + Y |
| Edit the cell you're in | F2 | Ctrl + U |
| Fill down | Ctrl + D | Cmd + D |
| Insert today's date | Ctrl + ; | Ctrl + ; |
Formulas
| What | Windows | Mac |
|---|---|---|
| AutoSum | Alt + = | Cmd + Shift + T |
| Lock a reference | F4 | Cmd + T |
| Show formulas instead of results | Ctrl + ` | Ctrl + ` |
Formatting and lists
| What | Windows | Mac |
|---|---|---|
| Bold | Ctrl + B | Cmd + B |
| Format Cells | Ctrl + 1 | Cmd + 1 |
| Show or hide the filter buttons | Ctrl + Shift + L | Cmd + Shift + F |
| Create a table | Ctrl + T | Ctrl + T |
On a laptop you sometimes need the Fn key for Home, End, Page Down and the F keys. Some combinations differ by keyboard and Excel version.