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.
Mac keys and context
The first Ctrl+A selects Table data; the next includes headers. Begin in Table data, not an ordinary range.
This catalog has no verified Mac binding for this operation. The steps below describe Windows. Choose Windows to use the walkthrough and recall controls.
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.
Expected result: The selection expands within the Table from data to data with headers.
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.