Tables · original practice scenario
Select an Excel Table data area and then its headers
The Expenses Table has data you want to select without surrounding worksheet cells.
Start here: Windows worksheet; active cell inside the data area of a structured Excel Table
Further presses or starting outside the Table can expand the selection to the worksheet.
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 Ctrl+A selects Table data; the next includes headers. Begin in Table data, not an ordinary range.
Ctrl+A
Select an entire table. Microsoft reference ↗
Walk through the operation
- Click a data cell inside Expenses.
- Press Ctrl+A once for its data area.
- Press it a second time to include headers.
Instruction 1 of 3: Click a data cell inside Expenses.
Expected result: The selection expands within the Table from data to data with headers.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Select an Excel Table column data area
- Select an Excel Table data row from its first cell
- 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.