Behavior changes as the shortcut is used more than once.

First time: column data.

Second time: column data + column header.

Video thumbnail for Anatomy of an Excel Table

Third time: entire worksheet column.

The videos below demonstrate this shortcut.

Video thumbnail for Conditional formatting formula in a table

Video thumbnail for Data validation with an Excel table

Video thumbnail for How to build a simple dynamic chart

Video thumbnail for Formulas to query a table

Video thumbnail for How to pick names out of a hat with Excel