Tables · original practice scenario
Select an Excel Table column data area
A structured Excel Table named Expenses has a Cost column.
Start here: Active data cell inside a structured Excel Table
Outside a Table, Ctrl+Space selects a whole worksheet column.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Windows keys and context
The first press selects the Table column data; the second includes its header. This is a Table-specific selection context.
Ctrl+Space
Select a table column. Microsoft reference ↗
Walk through the operation
- Click a data cell in the Cost column.
- Press Ctrl+Space once.
- Press it again if the header must be included.
Instruction 1 of 3: Click a data cell in the Cost column.
Expected result: The Table column is selected at the requested scope.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Select an Excel Table data row from its first cell
- Select an Excel Table data area and then its headers
- Toggle an Excel Table Total Row
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.