Learn › Excel › Select data to the last cell
Excel select data shortcut: Ctrl + Shift + ↓
Select a column of data down to the last filled cell, without the empty cells below.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + Shift + Down arrow extends the selection from the active cell down to the last filled cell, where the data ends. In the same way, Ctrl + Shift + Right arrow selects along a row.
When to use it
Use it to select a long list without scrolling or dragging, to format it, copy it, add it up or sort it. It works the same on ten rows and on ten thousand. Unlike Ctrl + Space, it does not select the empty cells below your data.
How to do it
- Click the first cell of the data, for example the first amount under the header.
- Press Ctrl + Shift + Down arrow (on a Mac: Command + Shift + Down arrow).
- To select a whole block, start in its top left cell and press Ctrl + Shift + Right arrow, then Ctrl + Shift + Down arrow.
A quick example
In the orders table, click the first amount, D2, and press Ctrl + Shift + Down arrow. D2 to D11 is selected, and the status bar at the bottom shows the ten numbers added up, 200.
Ctrl + Shift + Down arrow, Ctrl + Space and Ctrl + A
Ctrl + Space selects the whole column, including every empty cell down to the last row of the sheet. Ctrl + Shift + Down arrow selects only the cells that have data, and Ctrl + A selects the whole table or sheet. Select only the data when you copy or format, and the whole column when you insert, hide or delete a column.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar. If you are editing a cell, press Enter or Escape first.
- The selection jumps far down: the cell below your start is empty, so Excel runs on to the next filled cell or to the end of the sheet. Click a filled cell first.
- Only part of the list is selected: there is an empty cell inside the list. Press Ctrl + Shift + Down arrow again to continue to the next block.
- On a Mac use Command + Shift + Down arrow.
Quick answers
What is the shortcut to select a column of data in Excel?
Click the first cell and press Ctrl + Shift + Down arrow. It selects down to the last filled cell. On a Mac use Command + Shift + Down arrow.
How do I select down to the last row with data?
Click the first cell of the column and press Ctrl + Shift + Down arrow. Excel stops at the last filled cell of the block.
What is the difference between Ctrl + Space and Ctrl + Shift + Down arrow?
Ctrl + Space selects the whole column, including all the empty cells. Ctrl + Shift + Down arrow selects only the cells that have data.

