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 apply conditional formatting to a table with a formula.
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.
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.
In this video, we'll review the key terminology associated with Excel Tables.
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.
