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 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.
How to pick names out of a hat with Excel
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.
Anatomy of an Excel Table
In this video, we'll review the key terminology associated with Excel Tables.
Formulas to query a 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.
How to copy and lock structured references
In this video, we'll look at how to copy and lock structured references in a formula. Structured references are a special syntax used by Excel Tables.

Download 200+ Excel Shortcuts

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