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.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.
In this video we'll look at how to apply data validation to an Excel Table.
Because tables support structured references, you can learn a lot about a table with simple formulas. In this video, we'll look at some formulas you can use to query a table.
In this video we'll look at how to apply conditional formatting to a table with a formula.
In this video, we'll review the key terminology associated with Excel Tables.