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 review the key terminology associated with Excel Tables.
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
In this video we'll look at how to apply conditional formatting to a table with a formula.
In this video, we look at how to simulate a random drawing to pick winners in a contest with Excel, using the RAND and RANK functions together.
In this video we'll look at how to apply data validation to an Excel Table.