Tables · original practice scenario
Select an Excel Table data row from its first cell
A structured Table spans B:F; row 8 is the expense record to inspect.
Start here: Windows worksheet; active cell is the first data cell in an Excel Table row
This is not the Shift+Space command that selects an entire worksheet row.
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 starting cell matters: Microsoft specifies the first cell of the Table row for this selection.
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 B8, the first Table data cell in that row.
- Press Ctrl+Shift+Right.
Expected result: The data cells of that Table row are selected.
Related walkthroughs
- Select an Excel Table column data area
- 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.