25 Excel Keyboard Shortcuts That Actually Save Time
Most shortcut lists are padded with things nobody uses. This one is not. These are the shortcuts that heavy Excel users press hundreds of times a day, grouped by job. Learn them a group at a time — a week per group — and your hands will stop leaving the keyboard. Mac users: swap Ctrl for Cmd unless noted.
Moving around (learn these first)
- Ctrl + Arrow — jump to the edge of the data in that direction.
- Ctrl + Home — back to A1.
- Ctrl + Page Up / Page Down — previous / next sheet tab.
- Ctrl + G — Go To any cell or named range.
- F5 — same as Ctrl+G, and its Special… button finds blanks, formulas, and constants.
Selecting
- Ctrl + Shift + Arrow — select to the edge of the data. The workhorse.
- Ctrl + A — select the current region; press again for the whole sheet.
- Ctrl + Space — select the entire column; Shift + Space the entire row.
- Ctrl + Shift + End — select to the last used cell.
Editing
- F2 — edit the active cell without reaching for the mouse.
- F4 — while editing, cycles \$A\$1 → A\$1 → \$A1 → A1. Outside editing, repeats your last action.
- Ctrl + D — fill down from the cell above; Ctrl + R fills right.
- Ctrl + Enter — fill every selected cell with the same entry in one stroke.
- Alt + Enter — line break inside a cell.
- Ctrl + ; — insert today’s date as a static value.
- Ctrl + Z / Ctrl + Y — undo / redo. You knew undo; redo completes the pair.
Formatting and structure
- Ctrl + 1 — Format Cells. The single most useful dialog in Excel.
- Ctrl + Shift + L — toggle filters on the header row.
- Ctrl + T — convert the current region to a Table (structured references, auto-expanding ranges).
- Ctrl + Plus / Ctrl + Minus — insert / delete rows, columns, or cells.
- Alt + = — AutoSum whatever is above or beside you.
Power moves
- Ctrl + Shift + V — paste values only (Excel 365; older versions use Alt, E, S, V).
- Ctrl + ` — show all formulas instead of results. Great for auditing.
- Ctrl + E — Flash Fill: type one example of the transformation you want, and Excel infers the rest.
- Alt alone — reveals key hints for the entire Ribbon. Every menu command becomes a shortcut.
If you adopt only three: Ctrl + Shift + Arrow for selection, F4 for locking references, and Ctrl + 1 for formatting. Those three alone eliminate most of the mousing in a typical Excel session.