Ctrl + an arrow key jumps the cursor to the last non-empty cell in that direction, so you cross a thousand-row column in one keystroke instead of scrolling. Hold Shift as well — Ctrl + Shift + Arrow — and it selects the whole run as it goes: the fastest way to grab a column of data whose length you don't know. It also tells you where your data really ends, since a stray blank stops the jump early.

1. 1Click any cell inside your data.
2. 2Press Ctrl + ↓ to jump to the bottom of the column (or ↑ ← → for the other edges).
3. 3Add Shift — Ctrl + Shift + ↓ — to select every cell from here to that edge.

Press the shortcut to play it on a sample sheet.

• Jump to the bottom of a long ledger without scrolling.
• Select a whole column to copy or format, however long it is.
• Spot where the data actually ends — a gap stops the jump short.

• Fill down / right — see its own page, with a live demo.