Excel Keyboard Shortcuts Cheat Sheet
A reference list of 70+ Excel shortcuts organized by category: editing, navigation, formatting, formulas, and data handling.
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