Excel keyboard shortcuts
Excel has hundreds of shortcuts, but most people lean on the same thirty or so every day. This page lists only those, grouped by task with the ones you’ll use most at the top. Type in the box to find one fast, switch between Windows and Mac keys, or print the list as a one-page cheat sheet.
Every Windows shortcut here was tested in desktop Excel. The Mac keys come from Microsoft’s own list and haven’t been pressed on a Mac by us yet, so they’re marked until we have.
Two habits make most of these easier. Hold Shift with any move shortcut to select as you go: Ctrl+Down jumps to the bottom of the data, and Ctrl+Shift+Down selects everything on the way. And to insert or delete whole rows, select the rows first with Shift+Space, then press Ctrl+Shift+= or Ctrl+-.
No shortcut on this page matches. This list is the 30 or so worth learning first, so try a broader word like “paste”, “select” or “format”.
Copy, paste and undo
| What it does | Windows | Mac |
|---|---|---|
| Copy | Ctrl+C | Cmd+C |
| Cut | Ctrl+X | Cmd+X |
| Paste | Ctrl+V | Cmd+V |
| Paste Special (values, formats and more) | Ctrl+Alt+V | Cmd+Ctrl+V |
| Undo | Ctrl+Z | Cmd+Z |
| Redo | Ctrl+Y | Cmd+Y |
Move around
| What it does | Windows | Mac |
|---|---|---|
| Jump to the last filled cell in a direction | Ctrl+Arrow | Cmd+Arrow |
| Go to cell A1 | Ctrl+Home | Ctrl+Home |
| Next or previous sheet | Ctrl+PageDown / Ctrl+PageUp | Option+Right / Option+Left |
| Find | Ctrl+F | Ctrl+F |
Select
| What it does | Windows | Mac |
|---|---|---|
| Select to the end of the data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Select the data around the cell, press again for the whole sheet | Ctrl+A | Cmd+A |
| Select the whole column | Ctrl+Space | Ctrl+Space |
| Select the whole row | Shift+Space | Shift+Space |
Formulas
| What it does | Windows | Mac |
|---|---|---|
| Edit the active cell | F2 | F2 |
| Lock a reference ($A$1) while editing | F4 | Cmd+T |
| AutoSum | Alt+= | Cmd+Shift+T |
| Enter the same formula in every selected cell | Ctrl+Enter | Cmd+Return |
| Show formulas instead of results | Ctrl+` | Ctrl+` |
Format
| What it does | Windows | Mac |
|---|---|---|
| Bold | Ctrl+B | Cmd+B |
| Strikethrough | Ctrl+5 | Cmd+Shift+X |
| Open Format Cells | Ctrl+1 | Cmd+1 |
| Currency format | Ctrl+Shift+$ | Ctrl+Shift+$ |
| Percent format | Ctrl+Shift+% | Ctrl+Shift+% |
Rows and columns
| What it does | Windows | Mac |
|---|---|---|
| Insert rows or columns (select whole rows or columns first) | Ctrl+Shift+= | Ctrl+Shift+= |
| Delete rows or columns | Ctrl+- | Cmd+- |
| Hide rows or columns | Ctrl+9 / Ctrl+0 | Ctrl+9 / Ctrl+0 |
| Fit column width to the contents | Alt, H, O, I | No shortcutMac Excel has no ribbon key tips. Double-click the column's right border instead. |
Files
| What it does | Windows | Mac |
|---|---|---|
| Save | Ctrl+S | Cmd+S |
| Open | Ctrl+O | Cmd+O |
| New workbook | Ctrl+N | Cmd+N |
| Ctrl+P | Cmd+P |
Cmd A dashed key means we took it from Microsoft's list and haven't pressed it on a Mac yet. On many Mac keyboards the F keys need Fn held down.
Practice it for real
Short drills in an Excel-style grid, checked the moment you press Enter.