Shortcutdrill / Excel shortcuts / Cheat sheet
Excel shortcuts cheat sheet: one printable page, Windows and Mac
107 shortcuts on one page, grouped the way the work happens, with the Windows and Mac keys side by side. Print this page (it is laid out for A4 and Letter), or get the PDF by email and we will also send the ten drills that make the shortcuts stick.
The ten worth learning first
| What | 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 |
| AutoSum | Alt+= | Cmd+Shift+T |
| Fill down | Ctrl+D | Cmd+D |
| Lock a reference ($A$1) | F4 | Cmd+T |
| Filters on or off | Ctrl+Shift+L | Cmd+Shift+F |
| Insert or delete rows | Ctrl+Shift+= / Ctrl+- | Control+Shift+= / Control+- |
| Currency and percent formats | Ctrl+Shift+4 / Ctrl+Shift+5 | Control+Shift+4 / Control+Shift+5 |
| Paste values | Ctrl+Shift+V | Cmd+Shift+V |
| Go to A1 / last cell | Ctrl+Home / Ctrl+End | Fn+Cmd+Left / Fn+Cmd+Right |
Moving around
| Jump to the edge of the data | Ctrl+Arrow | Cmd+Arrow |
| Go to cell A1 | Ctrl+Home | Fn+Cmd+Left arrow |
| Go to the last used cell | Ctrl+End | Fn+Cmd+Right arrow |
| Go to the start of the row | Home | Fn+Left arrow |
| Move one cell right or left | Tab / Shift+Tab | Tab / Shift+Tab |
| Move one cell down or up | Enter / Shift+Enter | Return / Shift+Return |
| Move one screen down or up | Page Down / Page Up | Fn+Down / Fn+Up arrow |
| Move one screen right or left | Alt+Page Down / Alt+Page Up | Fn+Option+Down / Fn+Option+Up arrow |
| Next or previous worksheet | Ctrl+Page Down / Ctrl+Page Up | Option+Right / Option+Left arrow |
| Go to a cell or named range | Ctrl+G or F5 | Ctrl+G |
| Scroll back to the active cell | Ctrl+Backspace | Cmd+Delete |
| Find | Ctrl+F | Cmd+F |
| Find and replace | Ctrl+H | Control+H |
| Go to the cells a formula refers to | Ctrl+[ | Control+[ |
| Go to the formulas that use this cell | Ctrl+] | Control+] |
Selecting
| Extend the selection to the edge of the data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Extend the selection one cell | Shift+Arrow | Shift+Arrow |
| Select the whole row | Shift+Space | Shift+Space |
| Select the whole column | Ctrl+Space | Control+Space |
| Select the current table (twice: the whole sheet) | Ctrl+A | Cmd+A |
| Select the current region | Ctrl+Shift+* | Control+Shift+Space |
| Select to the last used cell | Ctrl+Shift+End | Fn+Cmd+Shift+Right arrow |
| Select back to A1 | Ctrl+Shift+Home | Fn+Cmd+Shift+Left arrow |
| Select to the start of the row | Shift+Home | Fn+Shift+Left arrow |
| Extend the selection to a clicked cell | Shift+Click | Shift+Click |
| Add a separate cell or range to the selection | Ctrl+Click | Cmd+Click |
| Extend mode: arrows extend the selection until you press it again | F8 | Fn+F8 |
| Select only the visible cells (skip hidden rows) | Alt+; | Cmd+Shift+Z |
| Select the whole sheet | Ctrl+Shift+Space | Cmd+A twice |
Editing
| AutoSum | Alt+= | Cmd+Shift+T |
| Fill down / fill right | Ctrl+D / Ctrl+R | Cmd+D / Cmd+R |
| Insert today's date | Ctrl+; | Control+; |
| Insert the current time | Ctrl+Shift+; | Cmd+; |
| Undo / redo | Ctrl+Z / Ctrl+Y | Cmd+Z / Cmd+Y |
| Repeat the last action | F4 or Ctrl+Y | Cmd+Y |
| Copy, cut, paste | Ctrl+C / Ctrl+X / Ctrl+V | Cmd+C / Cmd+X / Cmd+V |
| Paste Special | Ctrl+Alt+V | Control+Cmd+V |
| Paste values only | Ctrl+Shift+V | Cmd+Shift+V |
| Clear the selected cells | Delete | Fn+Delete |
| Edit the active cell | F2 | Control+U |
| New line inside a cell | Alt+Enter | Control+Option+Return |
| Fill the selection with what you typed | Ctrl+Enter | Control+Return |
| Copy the formula from the cell above | Ctrl+' | Control+' |
| Copy the value from the cell above | Ctrl+Shift+" | Control+Shift+" |
| Flash Fill | Ctrl+E | Ctrl+E |
| Insert a hyperlink | Ctrl+K | Cmd+K |
| Add or edit a note on the cell | Shift+F2 | Fn+Shift+F2 |
| Check spelling | F7 | Fn+F7 |
| Cancel the entry | Esc | Esc |
Rows, columns and sheets
| Insert rows or columns | Ctrl+Shift+= | Control+Shift+= |
| Delete the selected rows or columns | Ctrl+- | Control+- |
| Hide rows | Ctrl+9 | Control+9 |
| Unhide rows | Ctrl+Shift+9 | Control+Shift+9 |
| Hide columns | Ctrl+0 | Control+0 |
| Unhide columns | Ctrl+Shift+0 | Control+Shift+0 |
| Group rows or columns | Alt+Shift+Right arrow | Cmd+Shift+K |
| Ungroup rows or columns | Alt+Shift+Left arrow | Cmd+Shift+J |
| Insert a new worksheet | Shift+F11 | Fn+Shift+F11 |
| Rename the sheet | Alt, H, O, R | Double-click the tab |
Formatting
| Bold, italic, underline | Ctrl+B / Ctrl+I / Ctrl+U | Cmd+B / Cmd+I / Cmd+U |
| Strikethrough | Ctrl+5 | Cmd+Shift+X |
| Currency format | Ctrl+Shift+4 | Control+Shift+4 |
| Percent format | Ctrl+Shift+5 | Control+Shift+5 |
| Number format with thousands separator | Ctrl+Shift+1 | Control+Shift+1 |
| Date format | Ctrl+Shift+3 | Control+Shift+3 |
| Time format | Ctrl+Shift+2 | Control+Shift+2 |
| Scientific format | Ctrl+Shift+6 | Control+Shift+6 |
| General format (clear the number format) | Ctrl+Shift+` | Control+Shift+~ |
| Open Format Cells | Ctrl+1 | Cmd+1 |
| Outline border around the selection | Ctrl+Shift+7 | Cmd+Option+0 |
| Remove all borders | Ctrl+Shift+_ | Cmd+Option+- |
| Autofit column width | Alt, H, O, I | Double-click the column edge |
| Wrap text | Alt, H, W | Cmd+Option+Return in the ribbon |
Formulas
| Switch between relative and absolute references | F4 | Cmd+T |
| Show formulas instead of results | Ctrl+` | Control+` |
| Insert a function | Shift+F3 | Fn+Shift+F3 |
| Show the function's argument names | Ctrl+Shift+A | Control+Shift+A |
| Recalculate all open workbooks | F9 | Cmd+= |
| Recalculate the active sheet | Shift+F9 | Cmd+Shift+= |
| Enter an array formula (older Excel) | Ctrl+Shift+Enter | Cmd+Shift+Return |
| Expand or collapse the formula bar | Ctrl+Shift+U | Control+Shift+U |
| Paste a defined name into a formula | F3 | Fn+F3 |
| Create names from the selection | Ctrl+Shift+F3 | Fn+Ctrl+Shift+F3 |
| Evaluate part of a formula while editing | F9 (on the selected part) | Fn+F9 |
Data, filters and tables
| Turn filters on or off | Ctrl+Shift+L | Cmd+Shift+F |
| Open the filter menu of the active column | Alt+Down arrow | Option+Down arrow |
| Create a table | Ctrl+T | Cmd+T |
| Insert a chart on the sheet | Alt+F1 | Fn+Option+F1 |
| Insert a chart on its own sheet | F11 | Fn+F11 |
| Open the Sort dialog | Alt, A, S, S | Data tab, Sort |
| Remove duplicates | Alt, A, M | Data tab, Remove Duplicates |
| Insert a pivot table | Alt, N, V | Insert tab, PivotTable |
| Refresh all pivot tables and queries | Ctrl+Alt+F5 | Cmd+Option+F5 |
| Quick Analysis | Ctrl+Q | No equivalent |
Workbook and windows
| New workbook | Ctrl+N | Cmd+N |
| Open | Ctrl+O | Cmd+O |
| Save | Ctrl+S | Cmd+S |
| Save as | F12 | Cmd+Shift+S |
| Close the workbook | Ctrl+W | Cmd+W |
| Print | Ctrl+P | Cmd+P |
| Print preview | Ctrl+F2 | Cmd+P |
| Switch to the next open workbook | Ctrl+Tab or Ctrl+F6 | Cmd+~ |
| Collapse or expand the ribbon | Ctrl+F1 | Cmd+Option+R |
| Show the ribbon key tips | Alt | No equivalent |
| Freeze panes | Alt, W, F, F | View tab, Freeze Panes |
| Open the VBA editor | Alt+F11 | Fn+Option+F11 |
| Help | F1 | Fn+F1 |
shortcutdrill.com, practice every one of these on a live sheet.
A cheat sheet does not make them reflexes
Drills with a key-press limit do. Twenty-five are free, no account needed.
Start practicing
Shortcutdrill