The Shift + Space, Ctrl + Space guide
Ctrl+Space selects the whole column of the active cell, Shift+Space the whole row. On a Mac the column is ⌃+Space (Control, not Command).
Which is which
Shift+Space is the row: think of the wide space bar and a wide row. Ctrl+Space is the column. Both take the row or column of the active cell, edge to edge, so click a cell in the right place first. Clicking a row number or column letter does the same with the mouse.
With several cells selected, they take every row or column in the selection: select B2:D2 and Ctrl+Space selects columns B to D.
What you do with a whole row or column
- Insert or delete it: insert and delete rows needs the whole row selected first.
- Format it in one go, or hide it.
- Copy it to another sheet.
On a Mac
Microsoft lists ⌃+Space for the column and marks it as one that can clash with macOS. macOS uses Control+Space to switch input sources when you type in more than one language. If the keyboard language changes instead of the column getting selected, change or turn off that shortcut in System Settings → Keyboard → Keyboard Shortcuts → Input Sources.
Inside an Excel table
In a formatted table, Microsoft's rule is that the first Ctrl+Space selects the column's data only, and a second press selects the whole table column, header included.
FAQ
- What is the shortcut to select an entire column in Excel?
- Ctrl+Space on Windows. On a Mac it is Control+Space; if that switches your keyboard language, macOS is using it for input sources.
- What is the shortcut to select an entire row in Excel?
- Shift+Space, on Windows and Mac.
- Why does Ctrl+Space not work on my Mac?
- macOS uses Control+Space to switch input sources. Change that shortcut in System Settings → Keyboard → Keyboard Shortcuts → Input Sources, or click the column letter instead.



































































