The guide · Ctrl + Shift + arrow
How it works
Ctrl+↓ on its own jumps to the edge of the data. Adding Shift selects everything on the way. The same works in all four directions: Ctrl+Shift+→ selects to the end of a row. Hold Ctrl+Shift and press ↓ then → to select a whole table from its top-left cell.
Why it stops early
The jump goes to the last filled cell before a gap. If B15 is empty, the selection ends at B14, even when there are more numbers below. Excel does this on purpose, because a blank row often separates two tables. When you know the column continues, press the shortcut again: once to cross the gap, once more to reach the end. The status bar's Count is a quick check that you have every row.
Other ways to select a column
- Ctrl+Space selects the entire column, all the way to the bottom of the sheet, header included.
- Click, then Shift+click the last cell. Fine for short lists, slow when the end is 5,000 rows down.
- Type the range in the Name box (left of the formula bar), for example
B2:B21, and press Enter.
Common mistakes
- Stopping at the first gap. Check the last row of the selection before you copy or sum it.
- Starting on an empty cell. From a blank cell, the shortcut jumps to the next filled cell instead of selecting the column below.
- Including the header. Start from the first data cell, not the header, if the selection is going into a formula.
FAQ
- What is the shortcut to select to the end of a column in Excel?
- Ctrl+Shift+Down arrow on Windows, Command+Shift+Down arrow on a Mac. It selects from the active cell to the last filled cell below it.
- Why does Ctrl+Shift+Down stop before the end of my data?
- There is a blank cell in the column. The shortcut stops at the last filled cell before a gap. Press it again to continue past the blank.
- How do I select a whole table with the keyboard?
- Click the top-left cell, then press Ctrl+Shift+Down and Ctrl+Shift+Right. Ctrl+A inside a table also selects the block of data around the active cell.