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.

← All Excel shortcuts

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.

WindowsCtrl+Space
MacControl+Space

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.

English (US)Ctrl+Space
HrvatskiCtrl+Razmaknica
DeutschStrg+Leertaste
EspañolCtrl+Espacio
FrançaisCtrl+Espace
PortuguêsCtrl+Espaço
ItalianoCtrl+Spazio
TürkçeCtrl+Boşluk
Bahasa IndonesiaCtrl+Spasi
PolskiCtrl+Spacja

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

  1. Click one cell in the column you want.
  2. Press Ctrl + Space to select the whole column.
  3. Hold Shift and press the Right or Left arrow to add more columns.
Good to know: On a Mac, Control + Space is often taken by the keyboard-language switch. If it does nothing, turn that shortcut off in System Settings, Keyboard, Keyboard Shortcuts, Input Sources.

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.

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.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games