Exceljet

Quick, clean, and to the point

Select table column

Windows shortcut 
CtrlSpace
Mac shortcut 
⌃Space

This shortcut selects one or more table columns in a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once. First time: column data. Second time: column data + column header. Third time: entire worksheet column.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to use VLOOKUP with a table
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
What is an Excel Table
What is an Excel Table? This video provides an introduction to Excel Tables.
How to build a simple dynamic chart
In this video we'll look at how to build a simple dynamic chart in Excel. A dynamic chart automatically responds to changes in data.
Data validation with an Excel table
In this video we'll look at how to apply data validation to an Excel Table.
Conditional formatting formula in a table
In this video we'll look at how to apply conditional formatting to a table with a formula.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.