AI & Automation1 min read
Excel Keyboard Shortcuts Cheat Sheet
A printable one-page reference of the most useful Excel keyboard shortcuts for navigation, editing, formulas, and formatting.
In this article
Typing and clicking your way around Excel adds up to hours of wasted time every month. Print this cheat sheet and keep it at your desk — your hands stay on the keyboard, and your spreadsheets get built faster.
Navigation#
| Shortcut | What It Does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of a data region |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last used cell |
| Page Up / Page Down | Move one screen up or down |
| Ctrl + Page Up / Page Down | Switch to previous/next worksheet tab |
| Ctrl + G (or F5) | Open Go To |
Editing#
| Shortcut | What It Does |
|---|---|
| Ctrl + D | Fill down (copy cell above) |
| Ctrl + R | Fill right (copy cell to the left) |
| F2 | Edit the active cell |
| Alt + Enter | Start a new line inside a cell |
| Ctrl + Z / Ctrl + Y | Undo / Redo |
| Delete | Clear cell contents |
| Ctrl + Arrow, then Shift+Arrow | Extend selection while navigating |
| Ctrl + - | Delete selected cells/rows/columns |
| Ctrl + Shift + + | Insert cells/rows/columns |
Formulas#
| Shortcut | What It Does |
|---|---|
| F4 | Toggle absolute/relative cell reference ($) |
| Ctrl + ` | Show formulas instead of values |
| Alt + = | AutoSum the selected range |
| Ctrl + Shift + Enter | Enter an array formula (legacy Excel) |
| F9 | Recalculate all open workbooks |
| Shift + F3 | Open Insert Function dialog |
Formatting#
| Shortcut | What It Does |
|---|---|
| Ctrl + 1 | Open Format Cells dialog |
| Ctrl + B / Ctrl + I / Ctrl + U | Bold / Italic / Underline |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + 1 | Apply number format with 2 decimals |
Selection#
| Shortcut | What It Does |
|---|---|
| Ctrl + Shift + End | Select from active cell to last used cell |
| Ctrl + Shift + Home | Select from active cell to A1 |
| Ctrl + Space | Select the entire column |
| Shift + Space | Select the entire row |
| Ctrl + A | Select entire worksheet (or current data region) |
Save this page, pin it above your monitor, and you'll shave real time off every spreadsheet task this week. Got a bigger IT headache than a slow spreadsheet? Contact us — we're happy to help.
cheat-sheetexcelproductivity
