Excel Shortcut Cheat Sheet by Modifier Key
All 56 commands map to their actions. Ctrl alone covers more than half of everything worth memorising in Excel.
1–92 of 92
Rows per page:
1 / 1
| # | Shortcut | Action |
|---|---|---|
| 1 | Ctrl + N | New workbook |
| 2 | Ctrl + O | Open workbook |
| 3 | Ctrl + S | Save |
| 4 | F12 | Save As |
| 5 | Ctrl + P | |
| 6 | Ctrl + W | Close workbook |
| 7 | Alt + F4 | Close Excel |
| 8 | ||
| 9 | Editing Shortcuts | |
| 10 | ||
| 11 | Shortcut | Action |
| 12 | Ctrl + C | Copy |
| 13 | Ctrl + X | Cut |
| 14 | Ctrl + V | Paste |
| 15 | Ctrl + Z | Undo |
| 16 | Ctrl + Y | Redo |
| 17 | Ctrl + A | Select all |
| 18 | Delete | Delete cell content |
| 19 | F2 | Edit active cell |
| 20 | Ctrl + D | Fill down |
| 21 | Ctrl + R | Fill right |
| 22 | ||
| 23 | Navigation Shortcuts | |
| 24 | ||
| 25 | Shortcut | Action |
| 26 | Arrow Keys | Move one cell |
| 27 | Ctrl + Arrow Key | Jump to data edge |
| 28 | Home | Move to row start |
| 29 | Ctrl + Home | Go to A1 |
| 30 | Ctrl + End | Last used cell |
| 31 | Page Up/Down | Move one screen |
| 32 | ||
| 33 | Row & Column Shortcuts | |
| 34 | ||
| 35 | Shortcut | Action |
| 36 | Ctrl + Space | Select entire column |
| 37 | Shift + Space | Select entire row |
| 38 | Ctrl + Shift + + | Insert row/column |
| 39 | Ctrl + - | Delete row/column |
| 40 | Alt + H + O + I | AutoFit column width |
| 41 | ||
| 42 | Formatting Shortcuts | |
| 43 | ||
| 44 | Shortcut | Action |
| 45 | Ctrl + B | Bold |
| 46 | Ctrl + I | Italic |
| 47 | Ctrl + U | Underline |
| 48 | Ctrl + 1 | Format Cells |
| 49 | Ctrl + Shift + $ | Currency format |
| 50 | Ctrl + Shift + % | Percentage format |
| 51 | Ctrl + Shift + # | Date format |
| 52 | ||
| 53 | Formula Shortcuts | |
| 54 | ||
| 55 | Shortcut | Action |
| 56 | = | Start formula |
| 57 | Alt + = | AutoSum |
| 58 | F4 | Repeat last action / lock cell reference |
| 59 | Ctrl + ` | Show formulas |
| 60 | Shift + F3 | Insert function |
| 61 | ||
| 62 | Worksheet Shortcuts | |
| 63 | ||
| 64 | Shortcut | Action |
| 65 | Shift + F11 | New worksheet |
| 66 | Ctrl + Page Up | Previous sheet |
| 67 | Ctrl + Page Down | Next sheet |
| 68 | ||
| 69 | Data Handling Shortcuts | |
| 70 | ||
| 71 | Shortcut | Action |
| 72 | Ctrl + T | Create table |
| 73 | Ctrl + Shift + L | Apply/remove filter |
| 74 | Alt + Down Arrow | Open filter dropdown |
| 75 | Ctrl + ; | Insert current date |
| 76 | Ctrl + Shift + : | Insert current time |
| 77 | ||
| 78 | Search & Replace | |
| 79 | ||
| 80 | Shortcut | Action |
| 81 | Ctrl + F | Find |
| 82 | Ctrl + H | Replace |
| 83 | Ctrl + G | Go To |
| 84 | ||
| 85 | Quick Power User Shortcuts ⚡ | |
| 86 | ||
| 87 | Shortcut | Action |
| 88 | Ctrl + Shift + Arrow | Select data range |
| 89 | Alt | Show Ribbon shortcuts |
| 90 | Ctrl + Shift + $ | Currency |
| 91 | Ctrl + Shift + ~ | General format |
| 92 | Ctrl + K | Insert hyperlink |
Double-click to expand