Ctrl+↓ jumps to the last filled cell; add Shift — Ctrl+Shift+↓ — to select everything from here to that edge in one press. Today we look at exactly how that jump decides where to stop, and the stray-blank case where it stops too soon.
Moving through a workbook at speed — and the one blank cell that quietly breaks your range.
Know why Ctrl+↓ stops early on a gap? Skip to the move map ↓
You're in A1 at the top of a column with 500 rows of data — except row 250 was left blank by accident. You press Ctrl+↓ once to shoot to the bottom. Where does the cursor land?
Commit to a guess first, then read on. The answer is the single most useful thing to understand about how Excel navigation works — and it is why a stray blank cell can quietly wreck a formula's range.
Lesson 002 gave you the contract: your hand stays on the keyboard, and you move by data region instead of scrolling. This lesson is the vocabulary that makes good on it. Almost all of your time in a model is spent going somewhere and grabbing something — jump to the bottom of a column, select it, hop to another sheet, chase a number back to where it came from. Do that with the mouse and you scroll, hunt, and misclick; do it with four families of keystroke and you move at the speed of thought. But the moves are not magic arrows. They read the shape of your data, and the moment you understand what they read, the surprises stop.
Start with the workhorse, Ctrl+arrow. Here is the rule that governs it, and it is worth saying precisely: from a filled cell, Ctrl+↓ jumps to the last filled cell before the next blank. Not the bottom of the column — the end of the current unbroken run of data. If every cell from A1 to A500 is filled, one press lands you on A500. But drop a single blank into row 250 and you have split the column into two runs, and the jump from A1 stops dead at A249, the last cell before the gap. (The blank works both ways: start on a blank cell and the same keystroke leaps forward to the next filled cell.) That is the answer to the prediction, and it is not a quirk to memorize — it is the whole mental model. The keyboard does not scroll to the end; it reads where your data stops.
The keyboard doesn't scroll to the bottom. It reads where the data stops — and a stray blank is a wall.
| Cell | Value | What the jump sees |
|---|---|---|
| A1 | 120 | ← cursor starts here |
| A2 | 118 | |
| A249 | 132 | Ctrl+↓ from A1 stops HERE — last cell of run 1 |
| A250 | (blank) | the wall |
| A251 | 141 | run 2 begins |
| A500 | 129 | Ctrl+↓ from A251 reaches HERE — the true bottom |
To select a run instead of just landing on it, add Shift: Ctrl+Shift+↓ grabs everything from the active cell to that same edge. Same rule, same wall — which is exactly where it bites, as you will see in a moment. Beyond the run, three more moves cover almost everything else you do: Ctrl+End jumps to the far corner of the sheet's used range regardless of gaps; Ctrl+A (or Ctrl+Shift+*) selects the whole current regionTerm of artThe contiguous block of filled cells around the active cell, bounded on every side by blank rows and columns. Excel treats it as one table — the unit Ctrl+A grabs and the unit a chart or PivotTable defaults to. around you; and to go somewhere absolute rather than relative to data, Ctrl+G (or F5) opens Go To and the Name Box left of the formula bar takes a typed address like M400, a named range like TaxRate, or a cell on another sheet.
| What you need | Keystroke | What it reads |
|---|---|---|
| Jump to a data edge | Ctrl+arrow | the last filled cell before a blank |
| Select the run to that edge | Ctrl+Shift+arrow | from here to the wall |
| Select the whole current block | Ctrl+A | the contiguous region around you |
| Jump to the sheet's true last cell | Ctrl+End | the far corner of the used range |
| Go to any address or named range | Ctrl+G / Name Box | an absolute location, any sheet |
| Hop between worksheets | Ctrl+PgUp / PgDn | tab to tab, no mouse |
| Follow a formula to its source, then return | Ctrl+[, then F5 ↵ | the precedent cell, and back |
Column A holds data in A1:A100, then A101 is blank, then someone appended more data in A102:A200. Your cursor is in A1 and you press Ctrl+Shift+↓ to "select the whole column of data." What do you actually select?
The last family is the one that separates someone who can drive a model from someone who can only read it. When you land on a formula like =Rev*Margin and want to know where Margin actually comes from, Ctrl+[ follows the reference straight to its precedentTerm of artA cell that a formula depends on — the source it reads from. Ctrl+[ jumps to the precedent of the reference under the cursor; the dependents (cells that read this one) run the other way. cell, even on another sheet. You read it, then press F5 and Enter: Go To remembers where you just were, so it snaps you back to the formula. That round-trip — out to the source, back to your place — is how a reviewer walks a model's logic without ever scrolling or losing the thread. It is the keystroke embodiment of the FAST standard'sReferenceThe Flexible / Appropriate / Structured / Transparent modelling standard (CC-licensed). Its through-line: a model must be legible to someone who did not build it — which is exactly what fast source-tracing lets a reviewer do. transparency rule, and it is the habit you'll lean on the day you have to interrogate someone else's workbook fast.
Your turn · trace the logic
With the cursor in F50, press Ctrl+[ — Excel follows the reference and jumps to the precedent cell that Margin points to, wherever it lives, including another sheet. Read it. Then press F5 (or Ctrl+G) and hit Enter: Go To pre-fills the box with your previous cell, so Enter snaps you back to F50. So: Ctrl+[ out to the source, F5 then Enter back home. That is the reviewer's round-trip — walk a formula's logic and never lose your place.
The assumption: "To reach the bottom of my data I just press Ctrl+↓ — it always lands on the last row."
Why it's wrong: Ctrl+arrow reads runs of data, not the whole column. One stray blank — a spacer row, a merged cell, a single missing value — stops the jump early. Most people land somewhere unexpected, shrug, and keep going; but if you then Ctrl+Shift+↓ to "select it all," you silently grab only the first block and feed a half-length range into your SUM — no error, just a wrong number. The rule to carry: treat a jump that lands early as your data telling you there is a gap. When you need the true extent of a sheet, Ctrl+End and the Name Box won't lie to you.
Open a scratch workbook and type a column of about twenty numbers — but leave one cell blank in the middle. Now, keyboard only: from the top cell press Ctrl+↓ and note where it stops (the wall). Step past the gap and press Ctrl+↓ again to reach the true bottom. Back at the top, press Ctrl+Shift+↓ and watch it select only the first block. Then Ctrl+End to see the sheet's true last cell, and Ctrl+G to jump to a specific cell and back. Finally fill the blank and repeat — now one press crosses the whole column.
Right result: before you press a key, you can say where the cursor will land and why. That predictive certainty — not raw speed — is the skill.
≈ 10 minutes · a scratch workbook, any numbers · this is toolkit cards E1 + E2's proof in miniature
Before you scroll on — in one sentence, what is the single thing to remember?
Ctrl+arrow reads runs of data, not whole columns — so a jump that stops early isn't a glitch, it's a blank cell warning you where your data really ends.
Sources