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.
What is an Excel Table
What is an Excel Table? This video provides an introduction to Excel Tables.
Anatomy of an Excel Table
In this video, we'll review the key terminology associated with 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.
How to plot survey data in a bar chart
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.
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.

Download 200+ Excel Shortcuts

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