Excel Hack

Excel shortcut select to end of column

There is a shortcut key to expand the selection from the start cell to the end of the column. Pressing the shortcut key once will expand the selection to the end of the column of data you have already entered, and pressing it twice will expand the selection to the end of the sheet column. You can do the same thing with the mouse, but using the shortcut key is much faster.

Select to end of column shortcut

Windows
Ctrl + Shift + (Down Arrow key)

Mac
command + shift + (Down Arrow key) or control + shift + (Down Arrow key)

Use shortcut to select to the end of the column

To learn how to extend the selection to the last cell in a column using shortcut keys, see below.

Total Time: 1 minute

Select the cell to be the starting point

Select the cell to be the starting point

Select the cell that will be the starting point.

Extend the column selection to the end of the data

Extend the column selection to the end of the data

Press Ctrl + Shift + (Down Arrow key) to extend the column selection to the end of the data.

Extend the column selection to the end of the sheet

Select to the end of the sheet column

After extending the column selection to the end of the data, press Ctrl + Shift + (Down Arrow key) again.

You can now extend the column selection to the end of the sheet.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments