Excel Keyboard Shortcuts: 30 You Need (Windows and Mac)
Clicking through menus takes time. With a few keyboard shortcuts you select, copy, filter and fix a list in seconds. You do not need to learn all 30. Pick the ones you use most and add more later. A dash in the Mac column means: use the menu. Start with Fix 1.
Skip the shortcuts and clean the whole list with the free tools
A shortcut saves seconds. A tool cleans the whole sheet in one run. Try Clean Whitespace, Fix Text Case or Find and Remove Duplicates. They run on your own computer, and your original file stays as it is.
Excel shortcuts to select and move around your list
| What you want | Windows | Mac |
|---|---|---|
| Select the whole list | Ctrl+A | Cmd+A |
| Select a column | Ctrl+Space | Ctrl+Space |
| Select a row | Shift+Space | Shift+Space |
| Select down to the last filled cell | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Jump to the edge of your data | Ctrl+Arrow | Cmd+Arrow |
| Jump to the first cell (A1) | Ctrl+Home | Fn+Ctrl+Left |
| Jump to the last cell | Ctrl+End | Fn+Ctrl+Right |
| Open the Go To box | F5 | Ctrl+G |
Excel shortcuts to copy, paste and undo
| What you want | Windows | Mac |
|---|---|---|
| Copy | Ctrl+C | Cmd+C |
| Cut | Ctrl+X | Cmd+X |
| Paste | Ctrl+V | Cmd+V |
| Paste Special (for example values only) | Ctrl+Alt+V | Ctrl+Cmd+V |
| Undo | Ctrl+Z | Cmd+Z |
| Redo | Ctrl+Y | Cmd+Y (or Cmd+Shift+Z) |
| Repeat the last action | F4 | Cmd+Y |
| Fill down from the cell above | Ctrl+D | Ctrl+D |
| Save | Ctrl+S | Cmd+S |
More Excel shortcuts for editing, rows and columns
| What you want | Windows | Mac |
|---|---|---|
| Edit the cell | F2 | Ctrl+U (or F2) |
| New line inside a cell | Alt+Enter | Ctrl+Option+Return |
| Insert today's date | Ctrl+; | Ctrl+; |
| Insert rows or columns | Ctrl+Shift+Plus | Cmd+Shift+Plus |
| Delete rows or columns | Ctrl+Minus | Cmd+Minus |
| Hide rows | Ctrl+9 | Ctrl+9 |
| Hide columns | Ctrl+0 | Ctrl+0 |
To insert or delete a whole row or column, select it first with Shift+Space or Ctrl+Space.
Shortcuts to find, replace, filter and format
| What you want | Windows | Mac |
|---|---|---|
| Find | Ctrl+F | Cmd+F |
| Find and Replace | Ctrl+H | Ctrl+H |
| Turn the filter on or off | Ctrl+Shift+L | Cmd+Shift+F |
| Flash Fill (Excel copies your pattern) | Ctrl+E | Ctrl+E |
| Format cells | Ctrl+1 | Cmd+1 |
| Turn a list into a table | Ctrl+T | Ctrl+T |
Flash Fill example: type the first name from a full name in the next column. Start the second one and press Ctrl+E. Excel fills the rest. See also our guide on clearing filters.
Excel shortcuts: before and after
| Job | With the mouse | With a shortcut |
|---|---|---|
| Select a column | Click the letter | Ctrl+Space |
| Open Replace | Home, Find and Select, Replace | Ctrl+H |
| Turn the filter on | Data, Filter | Ctrl+Shift+L |
Small steps, but they add up over a big list. Shortcuts can differ a little by Excel version and keyboard.
Clean the whole sheet in one run
These free tools run on your own computer. Your file is never uploaded.
Questions about Excel shortcuts
Do these shortcuts work on a Mac?
Most do, with the Cmd key instead of Ctrl. The Mac column shows the keys. A dash means use the menu.
What does Ctrl+E do in Excel?
It starts Flash Fill. You type an example and Excel fills the rest of the column in the same pattern.
How do I undo a mistake?
Press Ctrl+Z (Cmd+Z on a Mac). Press it again to go back more steps.
How do I find and replace in Excel?
Press Ctrl+H, type what to find and what to put instead, then click Replace All.
Which shortcuts should I learn first?
Start with Ctrl+Z, Ctrl+C, Ctrl+V, Ctrl+A and Ctrl+Shift+L. Add more when these feel easy.
More Excel guides
How to Clear All Filters in Excel (and Show Hidden Rows)
Rows are missing? Clear all filters and bring back hidden rows.
Remove Duplicates in Excel Without Losing Data (3 Ways)
Find double rows and remove them, without deleting the wrong ones.
How to Keep Leading Zeros in Excel (ZIP Codes and IDs)
Excel turns 02110 into 2110. Here is how to get the zero back.