Excel Keyboard Shortcuts Cheatsheet — Printable PDF Reference
Excel Keyboard Shortcuts Cheatsheet — Printable PDF Reference
DodaTech
Updated Jun 20, 2026
4 min read
📄 Printable PDF: Use your browser’s Print (Ctrl+P / Cmd+P) → “Save as PDF” to get a printer-friendly PDF of this Excel shortcut cheatsheet.
Complete Excel keyboard shortcuts for faster spreadsheets, formulas, data analysis, PivotTables, charts, and workbook management. Windows shortcuts listed.
Navigation & Selection
| Shortcut | What it does |
|---|---|
Arrow keys | Move one cell |
Ctrl+Arrow | Jump to edge of data region |
Home | Move to start of row |
Ctrl+Home | Go to cell A1 |
Ctrl+End | Go to last used cell |
Page Up / Down | Move one screen up / down |
Alt+Page Down / Up | Move one screen right / left |
Ctrl+G or F5 | Go to dialog |
Shift+Arrow | Extend selection by one cell |
Ctrl+Shift+Arrow | Extend to edge of data region |
Shift+Space | Select entire row |
Ctrl+Space | Select entire column |
Ctrl+A | Select all (entire sheet) |
Ctrl+Shift+End | Extend to last used cell |
Ctrl+Shift+Home | Extend to A1 |
Shift+Page Down / Up | Extend selection one screen |
Ctrl+Shift+8 (*) | Select current region |
Editing & Formatting
| Shortcut | What it does |
|---|---|
F2 | Edit active cell |
Esc | Cancel editing |
Enter | Confirm edit and move down |
Ctrl+Enter | Fill selected cells with current entry |
Tab | Confirm edit and move right |
Shift+Enter | Confirm edit and move up |
Shift+Tab | Confirm edit and move left |
Ctrl+D | Fill down (copy from cell above) |
Ctrl+R | Fill right (copy from cell left) |
Ctrl+Z | Undo |
Ctrl+Y | Redo |
Ctrl+C / Ctrl+X / Ctrl+V | Copy / Cut / Paste |
Ctrl+Alt+V | Paste Special dialog |
Ctrl+B | Bold |
Ctrl+I | Italic |
Ctrl+U | Underline |
Ctrl+1 | Format Cells dialog |
Ctrl+Shift+~ | General number format |
Ctrl+Shift+$ | Currency format |
Ctrl+Shift+% | Percentage format |
Ctrl+Shift+# | Date format |
Ctrl+Shift+@ | Time format |
Ctrl+Shift+! | Number format (2 decimals) |
Ctrl+Shift+& | Apply outline border |
Ctrl+Shift+_ | Remove outline border |
Alt+H+0 | Increase decimal |
Alt+H+9 | Decrease decimal |
Formulas & Functions
| Shortcut | What it does |
|---|---|
= | Start a formula |
Alt+= | AutoSum (SUM) |
Shift+F3 | Insert Function dialog |
Ctrl+Shift+A | Insert function arguments |
F4 | Toggle absolute / relative reference |
Ctrl+ ` (backtick) | Show formulas instead of values |
F9 | Calculate all worksheets |
Shift+F9 | Calculate active sheet |
Ctrl+Alt+F9 | Force full calculation |
Ctrl+Enter | Enter formula in multiple cells |
Ctrl+Shift+Enter | Array formula (legacy) |
Alt+↓ | AutoComplete list (formula) |
Ctrl+Shift+U | Expand / collapse formula bar |
F2 then F9 | Evaluate part of formula (select then F9) |
Data Manipulation
| Shortcut | What it does |
|---|---|
Alt+D+T | Sort dialog |
Alt+A+S+S | Sort A to Z |
Alt+A+S+O | Sort Z to A |
Alt+A+T | Filter (toggle auto-filter) |
Alt+↓ | Open filter menu (in header) |
Ctrl+Shift+L | Toggle filter |
Alt+; | Select visible cells (goto special) |
Ctrl+Shift+: | Insert current time |
Ctrl+; | Insert current date |
Ctrl+\ | Select row differences |
Ctrl+Shift+\ | Select column differences |
Ctrl+Shift+{ | Select direct precedents |
Ctrl+Shift+} | Select direct dependents |
Ctrl+[ | Go to precedents |
Ctrl+] | Go to dependents |
Alt+A+E | Remove duplicates |
Alt+A+V+V | Data Validation dialog |
Alt+D+G+G | Consolidate dialog |
Alt+A+M | Merge & Center |
PivotTables & Charts
| Shortcut | What it does |
|---|---|
Alt+N+V | Create PivotTable |
Alt+JT | PivotTable Tools Analyze tab |
Alt+JS | PivotTable Tools Design tab |
Ctrl+Shift+* | Select entire PivotTable |
Alt+F1 | Create chart in new sheet |
F11 | Create chart in new sheet (sized) |
Alt+N+C+O | Create column chart |
Alt+N+C+L | Create line chart |
Alt+N+C+P | Create pie chart |
Ctrl+Page Down / Up | Next / Previous sheet |
Workbook Management
| Shortcut | What it does |
|---|---|
Ctrl+N | New workbook |
Ctrl+O | Open workbook |
Ctrl+S | Save workbook |
F12 | Save As |
Ctrl+P | |
Ctrl+W | Close workbook |
Ctrl+F4 | Close workbook |
Alt+F4 | Exit Excel |
Ctrl+F6 | Next workbook window |
Ctrl+Shift+F6 | Previous workbook window |
Ctrl+Tab | Next workbook |
Ctrl+Shift+Tab | Previous workbook |
Shift+F11 | Insert new worksheet |
Ctrl+Shift+F11 | Insert new sheet (right-click) |
Ctrl+Page Down | Next sheet |
Ctrl+Page Up | Previous sheet |
Alt+E+L | Delete sheet (legacy) |
Alt+E+M | Move or copy sheet |
F2 | Rename sheet (on sheet tab) |
Alt+O+H+R | Rename sheet (legacy) |
Cell Operations
| Shortcut | What it does |
|---|---|
Delete | Clear cell contents |
Ctrl+- | Delete cells / rows / columns |
Ctrl+Shift+=(+) | Insert cells / rows / columns |
Ctrl++ | Insert (alternative) |
Alt+H+D+R | Delete row |
Alt+H+D+C | Delete column |
Alt+H+I+R | Insert row |
Alt+H+I+C | Insert column |
Ctrl+Shift++ | Insert (all contexts) |
Ctrl+Alt+V, V | Paste Values only |
Ctrl+Alt+V, T | Paste Formatting only |
Ctrl+Alt+V, F | Paste Formula only |
Ctrl+Alt+V, W | Paste Column widths only |
F2 | Edit cell / enter formula mode |
Alt+Enter | Line break within a cell |
Ctrl+Delete | Delete text to end of line |
Printing & Layout
| Shortcut | What it does |
|---|---|
Ctrl+P | Print dialog |
Alt+P+S+P | Set print area |
Alt+P+S+C | Clear print area |
Alt+P+P | Print preview |
Ctrl+F2 | Print preview (alternate) |
Alt+P+S+O | Page Setup dialog |
Alt+P+M | Margins tab in Page Setup |
Alt+P+H | Header / Footer tab |
Alt+P+S | Sheet tab in Page Setup |
Alt+P+S+Z | Zoom to selection |
Ctrl+Shift+Arrow | Select until blank (for print range) |
See the full Excel guide for advanced data analysis and formulas.
Built by the developers of DodaTech
Doda Browser, DodaZIP & Durga Antivirus Pro