How to select entire column in Excel keyboard shortcut
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.