ShortcutdrillExcel shortcuts / navigation / Cross a gap between two blocks
Cross a gap between two blocks in Excel: Ctrl+Down arrow, twice (Mac: Cmd+Down arrow, twice)
| Windows | Ctrl+Down arrow, twice |
|---|---|
| Mac | Cmd+Down arrow, twice |
| Group | navigation |
Drill: Jump across the gap. Free, no sign-up.
What it does and when to use it
When data sits in two blocks with blank rows between them, the first Ctrl+Down reaches the end of the first block and the second lands on the start of the next. It works for any number of blank rows.
The common mistake
Holding the arrow key and scrolling through the gap instead. Two presses do it regardless of how wide the gap is.
Related shortcuts
- Go to a cell by address Ctrl+G, type the address, Enter
- Jump to a named range F5, pick the name, Enter
- Jump to the cells a formula uses Ctrl+[
- Return to where you came from F5, Enter
- Jump to the cells that use this one Ctrl+]
- The printable cheat sheet
Questions
How do I move between tables on the same sheet?
Ctrl+Down or Ctrl+Up twice: once to the edge of the current table, once to the next one.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill