Watch an experienced Excel person work and something looks wrong: the sheet is changing faster than their mouse is moving. Selections leap, formats snap on, whole columns total themselves. It isn’t talent, and it isn’t two hundred memorised shortcuts — the honest number is about a dozen, welded into habit.

The trap with shortcut lists is that they’re lists. Nobody adopts forty keystrokes from a poster. So this is the other approach: the dozen that matter, in the order they pay, with the instruction to take one per week. A habit a week is fifty a year, and you only need twelve.

Getting around (weeks one and two)

The mouse’s worst job is travel. From the navigation guide:

  • Ctrl + ↓/↑/←/→ — jump to the edge of the data. The bottom of a 10,000-row column in one press.
  • Ctrl + Home — back to the top corner, from anywhere.

Add Ctrl + PgDn / PgUp to walk between sheet tabs — the tab you’re looking for is two presses away, not a squint and a click.

Selecting (the one that changes everything)

  • Ctrl + Shift + ↓ — select from here to the edge of the data. This is the keystroke people gasp at: the whole column, selected precisely, in the time the mouse takes to start scrolling.
  • Ctrl + A — the current data block; press again for the whole sheet.
one keystroke, whole column 1,240 862 2,019 744 1,388 Ctrl Shift ↓ from the active cell to the last filled row — precisely, instantly, every time
The selection races the animation. In real life it's faster — and it never overshoots the way a scrolling mouse does.

Doing (weeks four to eight)

  • Ctrl + T — turn the block into a proper Table. The best three keys in Excel.
  • Alt + = — AutoSum. Sit under a column of numbers, press it, Enter. Totals without typing =SUM(.
  • F2 — edit the active cell in place, cursor at the end. Paired with Esc to back out without saving your fumble.
  • F4 — while editing, cycles the $ pinning on a reference (the dollar-sign system at typing speed). Bonus career: outside editing, F4 repeats your last action — format one cell, then F4 your way down the sheet.
  • Ctrl + 1 — Format Cells, the whole dialog. Number formats live here, and you visit more often than you think.

The specialists (from week nine, as needed)

  • Ctrl + ; — today’s date, as a fixed value (unlike TODAY(), it won’t change tomorrow — right for “logged on” stamps).
  • Ctrl + E — Flash Fill: type one example of the pattern you want (John Smith → J. Smith), press it, and Excel fills the column by imitation. Check its work; it’s a clever intern, not a recorded recipe.
  • Ctrl + ` (the backtick, top-left) — show every formula on the sheet at once. The auditing X-ray; press again to switch back.

And on the seventh day: Ctrl + S. Autosave has made people casual, and desktop Excel with autosave off is still one crash away from an afternoon’s silence.

How habits actually form

Three rules from someone who’s coached this. One shortcut a week — write the current one on a sticky note on the monitor edge; when you reach for the mouse to do that job, stop and use the keys, even though it’s slower the first ten times. Let the Alt-ribbon teach you the rest — tap Alt alone and Excel overlays letters on every ribbon command; any feature is a letter-sequence away, no memorising required. And don’t collect — a shortcut you use daily is an asset; forty you half-remember are a party trick.

The payoff isn’t really speed, though speed comes. It’s that the mechanical layer of Excel stops interrupting the thinking layer — selections, formats and totals happen at the speed of intention, and your attention stays on the actual question. That’s stage one of the path in general: make the ten-thousand-times moves cheap, and everything built on them gets cheaper.

Twelve keys, one a week, a quarter of a year. Then watch someone watch you work.