Excel Keyboard Shortcuts
The shortcuts that save the most time. On a Mac use Cmd in place of Ctrl for most of them.
31 of 31
| Keys | Group | What it does |
|---|---|---|
| Ctrl+C | Editing | Copy the selected cells. |
| Ctrl+X | Editing | Cut the selected cells. |
| Ctrl+V | Editing | Paste. |
| Ctrl+Z | Editing | Undo the last action. |
| Ctrl+Y | Editing | Redo the action you undid. |
| Ctrl+D | Editing | Fill down: copy the top cell of the selection into the cells below. |
| Ctrl+R | Editing | Fill right: copy the left cell of the selection into the cells to its right. |
| F2 | Editing | Edit the selected cell. |
| F4 | Formulas | While editing a formula, cycle the reference between B2, $B$2, B$2 and $B2. |
| Alt+= | Formulas | Insert a SUM formula for the cells above or to the left. |
| Ctrl+` | Formulas | Show formulas instead of their results. |
| Ctrl+Shift+Enter | Formulas | Enter a formula as an array formula in older versions of Excel. |
| Ctrl+Arrow keys | Moving | Jump to the edge of the data. |
| Ctrl+Home | Moving | Go to cell A1. |
| Ctrl+End | Moving | Go to the last used cell. |
| Ctrl+Shift+Arrow keys | Selecting | Select from the active cell to the edge of the data. |
| Ctrl+A | Selecting | Select all cells. |
| Ctrl+Space | Selecting | Select the whole column. |
| Shift+Space | Selecting | Select the whole row. |
| Ctrl+1 | Formatting | Open Format Cells. |
| Ctrl+B | Formatting | Bold. |
| Ctrl+Shift+% | Formatting | Format as a percentage. |
| Ctrl+Shift+$ | Formatting | Format as currency. |
| Ctrl+; | Formatting | Insert today's date. |
| Ctrl+T | Data | Turn the selected range into a table. |
| Ctrl+Shift+L | Data | Switch filters on or off. |
| Ctrl+Plus | Data | Insert cells, rows or columns. |
| Ctrl+Minus | Data | Delete cells, rows or columns. |
| Ctrl+S | File | Save the workbook. |
| Ctrl+F | File | Find. |
| Ctrl+H | File | Find and replace. |