Navigation
| Shortcut | What it does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of the current data region |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last used cell |
| Ctrl + Page Up / Page Down | Move between worksheet tabs |
| Ctrl + F | Find |
| Ctrl + G | Go To a specific cell or range |
Selecting
| Shortcut | What it does |
|---|---|
| Ctrl + Shift + Arrow | Select to the edge of the data |
| Ctrl + A | Select the whole table / sheet |
| Shift + Space | Select the entire row |
| Ctrl + Space | Select the entire column |
| Ctrl + Shift + End | Select to the last used cell |
Editing & Entry
| Shortcut | What it does |
|---|---|
| F2 | Edit the active cell |
| Alt + Enter | Start a new line inside the same cell |
| Ctrl + Enter | Fill all selected cells with the entry |
| Ctrl + D | Fill down from the cell above |
| Ctrl + R | Fill right from the cell to the left |
| Ctrl + ; | Insert today’s date |
| Ctrl + Shift + ; | Insert the current time |
Formulas & Calculation
| Shortcut | What it does |
|---|---|
| Alt + = | AutoSum |
| F4 | Toggle absolute / relative cell reference |
| Ctrl + ` | Show or hide all formulas |
| F9 | Recalculate all workbooks |
Formatting
| Shortcut | What it does |
|---|---|
| Ctrl + 1 | Open the Format Cells dialog |
| Ctrl + B / I / U | Bold / Italic / Underline |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + L | Toggle filters on a table |
| Ctrl + T | Create a table from the selected range |
Workbook
| Shortcut | What it does |
|---|---|
| Ctrl + C / X / V | Copy / Cut / Paste |
| Ctrl + Z / Y | Undo / Redo |
| Ctrl + S | Save |
| Ctrl + P | |
| Shift + F11 | Insert a new worksheet |
Print the one-page PDF below and keep it next to the keyboard — these pay for themselves the first week.
