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

Ctrl+Arrow (Cmd+Arrow on Mac) moves the active cell to the edge of a contiguous block of data in whichever direction you press — the exact same mechanic Excel uses, and just as central to fast navigation in Sheets as it is there. **The rule**: pressing Ctrl+Down from a cell containing data moves you to the last consecutively filled cell in that column before the next blank cell. If you start from a blank cell instead, Ctrl+Down jumps forward to the next filled cell, or all the way to the edge of the sheet if there's no more data in that direction. This dual behavior is identical to Excel's, so anyone with existing spreadsheet experience gets this shortcut for free in Sheets with zero relearning. **Why it matters more in a large operational spreadsheet**: shared Sheets files used for ongoing operational tracking — inventory logs, application trackers, response collection — often grow to thousands of rows over months of continuous use by multiple people. Manually scrolling to the bottom of such a sheet wastes real time daily; Ctrl+Down from any cell in your key column jumps there instantly regardless of how many rows have accumulated. **Combining with Shift**: adding Shift (Ctrl+Shift+Down, etc.) extends the current selection to that point instead of just moving the cursor, which is the fastest way to select an entire column or row of data before applying formatting or copying it elsewhere, without dragging the mouse across potentially thousands of rows. **A data-quality use case specific to shared sheets**: because Sheets is so often edited by multiple people with varying levels of care, a single stray blank cell breaking up what should be continuous data is a common real-world occurrence — pressing Ctrl+Down and having it stop unexpectedly early, well short of where you know your data actually ends, is a strong, fast signal that something got deleted or left blank partway through the range, worth investigating before trusting the dataset for a formula or chart. **Related shortcuts**: Ctrl+Home and Ctrl+End jump to the absolute start and end of the sheet's used range rather than the edge of one specific data block. The first press of Ctrl+A while inside a populated table selects that whole contiguous region in one step, which is a faster alternative to chaining several Ctrl+Shift+Arrow presses together when you want the entire table selected rather than just navigating to one edge of it. **Mistake to avoid**: assuming Ctrl+End will always land exactly at your data's true final row and column — just as in Excel, Sheets' notion of the 'used range' can extend beyond your visible data if a cell far outside your table once held formatting or a stray character that was later cleared but not fully reset, so Ctrl+End landing somewhere that looks empty is a hint to check for and remove that leftover formatting rather than assuming the shortcut is malfunctioning. **Behavior inside a named range or Table-like structure**: Sheets doesn't have a formal Table object the way Excel does, so Ctrl+Arrow's behavior is governed purely by where actual blank cells sit in the sheet rather than any defined table boundary — this makes it slightly more predictable than Excel in one specific sense (there's no separate Table-boundary behavior to learn on top of the base rule) but also means a Sheets range has no automatically enforced edge the way an Excel Table's boundary does, so a stray value accidentally typed one row below what you consider your 'real' table will silently extend what Ctrl+Down treats as the data region. **Using it while multiple people are editing simultaneously**: since Sheets syncs changes from other collaborators in near real time, it's possible for another person to add a row to the bottom of a shared table between the moment you last checked its extent and the moment you press Ctrl+Down — the shortcut always reflects the sheet's current live state, so landing one row further down than you remembered isn't a bug, it's evidence someone else just added data while you were looking elsewhere.