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.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.
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.
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.
How to use VLOOKUP with a table
In this video, we look at how to use VLOOKUP to lookup values in an Excel Table.
Data validation with an Excel table
In this video we'll look at how to apply data validation to an Excel Table.
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.

Download 200+ Excel Shortcuts

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