How to select entire column in Excel keyboard shortcut

• Release Jan 24, 2022Update Feb 24, 2022
• Written in Excel for Microsoft 365 version 2201

There are many tasks in Excel that require you to select an entire column. Therefore, it is a good idea to learn how to select multiple columns instead of just one. When selecting multiple columns, you can select not only adjacent columns but also non-adjacent columns. If you want to select an entire column, it is more efficient to use shortcuts instead of the mouse.

Select entire column shortcut

Select an entire column

Windows
Ctrl + Space

Mac
None

Selecting an entire column from the Go To dialog box

Windows
Ctrl + G or F5
Access Key: Alt + H + F + D + G

Mac
control + G or F5

Select an entire column

For information on how to select an entire column, see below.

Total Time: 1 minute

Select a cell

Select a cell in the column you want to select.

Complete selection of the entire column

By pressing Ctrl + Space, the entire column that contained the selected cell is now selected.

Select entire adjacent columns

Select a cell in the column you want to select.

Press Ctrl + Space to select the entire column.

Pressing Shift + → (Right Arrow key) allows you to select multiple adjacent columns. To select the entire column adjacent to the left side, press Shift + ← (Left Arrow key).

Select entire non-adjacent columns

Select a cell in the column you want to select.

Press Ctrl + Space to select the entire column.

Select a cell in the column that is far apart while holding down Ctrl.

Press Ctrl + Space to select the entire column away from the selected column.

Selecting an entire column from the Go To dialog box

Select any cell and press Ctrl + G or Alt + H + F + D + G.

The Go To dialog box will appear. Enter the cell range of the column (ex B:B) you want to reference in the Reference field, and press Enter.

The specified column is now selected.