Learn › Excel › Select a column
Excel select column shortcut: Ctrl + Space
Select a whole column with one key combination, then add more columns with Shift and the arrow keys.
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 + Space selects the whole column of the active cell, from row 1 to the bottom of the sheet. Once the column is selected, you can format, hide, insert or delete it in one step.
When to use it
Use it as the first step of many jobs: bold a whole column, set a number format for a column or hide it. Hold Shift and press the Right or Left arrow to add more columns.
How to do it
- Click one cell in the column you want.
- Press Ctrl + Space to select the whole column.
- Hold Shift and press the Right or Left arrow to add more columns.
A quick example
In the orders table, click the Region cell B4 and press Ctrl + Space: the whole column B is selected. Hold Shift and press the Right arrow, and column C is added. Now Ctrl + B bolds both columns at once.
Ctrl + Space, Shift + Space and Ctrl + A
Ctrl + Space selects a column, Shift + Space selects a row, and Ctrl + A selects the whole table or the whole sheet. Ctrl + Space also selects every empty cell down to the last row of the sheet. To select only the data of a column, click its first cell and press Ctrl + Shift + Down arrow.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- On a Mac, Control + Space often switches the keyboard language. Turn that shortcut off in System Settings, Keyboard, Keyboard Shortcuts, Input Sources.
- Only part of the column is selected: you are inside a table, where the first press selects the data of the column and the second press the whole column. Press it again.
- The shortcut selects more than you want: use Ctrl + Shift + Down arrow to select only the data.
Quick answers
What is the shortcut to select a whole column in Excel?
Press Ctrl + Space. Shift + Space selects the whole row.
How do I select more than one column?
Select the first column with Ctrl + Space, then hold Shift and press the right or left arrow key. Each press adds a column.
How do I select only the data in a column?
Click the first cell and press Ctrl + Shift + Down arrow. It selects down to the last filled cell, without the empty cells below.

