Skip to content
CtrlKFind a shortcut

Select Column Shortcut Excel Users Need

ExcelExcelRows and columnsChecked 2 Nov 2026

Select column

CtrlSpace

Select row

ShiftSpace

To the last filled cell

CtrlShiftDown

Excel for Mac column

ControlSpace

The select column shortcut excel offers is Ctrl + Space: click any cell in the column and press it to select the whole column from top to bottom. Shift + Space does the same for the row. Together they are the first step for inserting, deleting, hiding or formatting whole columns and rows.

To select only the filled part of a column instead of all million rows, use Ctrl + Shift + Down from the first cell. Extend it sideways or downward by adding Shift to the arrow keys.

Quick facts

  • Entire column

    Ctrl + Space

  • Entire row

    Shift + Space

  • Down to last data

    Ctrl + Shift + Down

  • More columns

    Then Shift + Right

  • Visible cells only

    Alt + ;

  • Mac

    Control + Space, Shift + Space

Shortcut to select entire column in Excel, step by step

  1. Click any cell in the column, for example C5.
  2. Press Ctrl + Space. Column C is highlighted from row 1 to the bottom of the sheet.
  3. To add columns D and E, press Shift + Right twice.
  4. Now apply an action: Ctrl + Minus to delete, Ctrl + 0 to hide, or a format.

Rows work the same way: Shift + Space, then Shift + Down for more rows. Selecting whole columns before formatting is better than selecting a fixed range, because new rows added later at the bottom pick up the same format automatically.

Select a column inside a table

In a formatted Excel table, the first Ctrl + Space selects just the data in that table column. Press it again to include the header, and a third time for the whole sheet column. This lets you format or copy a table column without touching cells below it. The filter and sort keys work on the same tables.

If Ctrl + Space switches your keyboard language, Windows is using that combination; change the language hot key or click the column letter instead.

Select visible cells only

After filtering or hiding rows, a normal selection still includes the hidden cells, and copying brings them along, which surprises many people when the pasted list is longer than what they saw. Select the range, press Alt + ;, then copy: only the visible rows are copied. The same trick makes it safe to delete only filtered rows, as explained in delete row shortcut.

When selection keys do not work

Problems and fixes
ProblemFix
Ctrl + Space changes languageChange the Windows input hot key, or click the column header
Ctrl + Shift + Down stops earlyThere is a blank cell; press it again to continue
Selection jumps to row 1048576The column is empty below; use Ctrl + Shift + Up to come back
Shift + Space types a spaceYou are editing a cell; press Esc first
A payroll clerk needs to format the Salary column as currency. She clicks one salary, presses Ctrl + Space and Ctrl + Shift + 4, and the whole column shows the currency format.

Frequently asked questions

What is the shortcut to select an entire column in Excel?
Ctrl + Space.
What is the shortcut to select a row in Excel?
Shift + Space.
How do I select a column only to the last filled cell?

Click the top cell and press Ctrl + Shift + Down.

How do I select several columns?

Press Ctrl + Space, then Shift + Right or Shift + Left.

How do I select only visible cells?

Select the range and press Alt + ;.

What is the select column shortcut on Mac Excel?
Control + Space.