How to Jump Between Data Blocks in Google Sheets (Ctrl+Arrow)

Ctrl+Arrow — Cmd+Arrow on a Mac — jumps the cursor to where a run of filled cells stops. Sheets inherits the mechanic from desktop spreadsheets, so anyone arriving with the habit keeps it, but there are a few things it does differently that are worth knowing before you rely on it. **What decides where you land.** Starting inside data, the cursor travels to the final filled cell before a gap appears. Starting on an empty cell, it travels forward to the first filled one it meets. If nothing lies ahead in that direction, it runs to the boundary of the grid. One rule, two apparent behaviours, and which you get depends entirely on whether the cell you left was occupied. **Sheets has no Table object, and that changes the answer.** In Excel, formatting a range as a Table gives it a defined boundary that navigation respects. Sheets has nothing equivalent — named ranges are labels, not structural edges. Movement is therefore governed purely by which cells happen to be blank. That is more predictable in one sense, since there is no second set of boundary rules layered on top. It also means a value typed one row below what you think of as the bottom of your table silently extends the region, and nothing marks the difference between deliberate data and a stray keystroke. **Holding Shift turns movement into selection.** Ctrl+Shift+Down grabs everything from the current cell to the landing point in one action. On a sheet with several thousand rows this is the only sane way to select a column of data — dragging is slow and easy to overshoot, and the name box requires knowing the row number you are aiming at. **Collaborative editing makes the landing point a live value.** Sheets applies other people's changes as they happen, so a shared tracker can gain rows between your last look at it and your next Ctrl+Down. Landing further than expected is not the shortcut misbehaving — it is the sheet reporting its present state, which includes whatever a colleague added thirty seconds ago. On a file several people write to, that is a feature worth trusting rather than a discrepancy worth investigating. **Stopping early is a signal, not a failure.** A run that halts well short of where you know the data ends means a cell in between is empty. On a sheet many people edit, that usually indicates a deleted row, a value cleared and not replaced, or an import that skipped a record. Noticing it before building a formula or a chart over the range is considerably cheaper than noticing afterwards, which makes the shortcut a quick integrity check as much as a navigation tool. **Related jumps.** Ctrl+Home returns to A1. Ctrl+End goes to the far corner of the used range, which is not necessarily where your data stops — a cell that once held content or formatting keeps the range extended after being cleared. Pressing Ctrl+A inside a populated region selects that whole region at once, which beats chaining several Ctrl+Shift+Arrow presses when you want the entire block rather than one edge of it.