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.
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 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.
