Select Entire Column
Windows
Ctrl+Space
Selects the whole column of the active cell.
Excel Select Entire Column Shortcut for Windows, Mac & Web
Selects the whole column of the active cell. Here's the keyboard shortcut for every version of Excel, plus other ways to do it.
Quick Answer
- Windows
- Ctrl+Space
- Mac
- Ctrl+Space
- Web
- Ctrl+Space
How to select entire column in Excel with the keyboard
- Open Excel and go to where you want to select entire column.
- Press Ctrl + Space on Windows or Ctrl + Space on Mac.
Excel Select Entire Column Shortcut for Windows
Press Ctrl + Space.
Excel Select Entire Column Shortcut for Mac
Press Ctrl + Space.
Excel Select Entire Column Shortcut for Excel Web
Press Ctrl + Space.
Related Shortcuts
Frequently asked questions
What is the Excel select entire column shortcut?
On Windows, press Ctrl + Space. On a Mac, press Ctrl + Space.
Is there a Mac shortcut to select entire column in Excel?
Yes: Ctrl + Space.
Does it work in Excel for the web?
Yes: Ctrl + Space.
Not yet verified · Last reviewed: not yet reviewed · Microsoft's official shortcut list