Excel Hack

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

Select a cell in the column you want to select.

Complete selection of the entire column

Selecting an entire column

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

Select entire adjacent columns

Select a cell

Select a cell in the column you want to select.

Make a selection of the entire column

Press Ctrl + Space to select the entire column.

Select multiple adjacent columns

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

Select a cell in the column you want to select.

Select an entire column

Press Ctrl + Space to select the entire column.

Select a cell in a distant column

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

Select an entire column away from the selected column

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

Selecting an entire column from the Go To dialog box

Select a cell

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

The Go To dialog box will appear

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 entire column is selected

The specified column is now selected.

Articles related to Column & Entire & Select & Shortcut