Select to the end of the column in Excel

Select to the end of the column in Excel: Ctrl+Shift+Down arrow (Mac: Cmd+Shift+Down arrow)

Windows	`Ctrl+Shift+Down arrow`
Mac	`Cmd+Shift+Down arrow`
Group	selection

Practice this shortcut

Drill: Select to the end of the column. Free, no sign-up.

What it does and when to use it

From any data cell, Ctrl+Shift+Down grabs everything to the last filled cell below. It is how you select 5,000 values in one press for a format, a copy or a delete.

The common mistake

Pressing it in a column with blanks and getting a short selection. Check the Name Box: it shows the selected range.

Related shortcuts

Select a column of data Ctrl+Shift+Down arrow
Select across a row Ctrl+Shift+Right arrow
Select the whole row Shift+Space
Select the whole column Ctrl+Space
Select the current table Ctrl+A
The printable cheat sheet

Questions

How do I select a very long column of data?

Ctrl+Shift+Down from the first value. If the column has gaps, Ctrl+Shift+End from the first value selects to the last row of the sheet data.

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