PivotTables · original practice scenario
Toggle a PivotTable field checkbox
The PivotTable Fields pane is open and the Amount field is not selected.
Start here: Windows PivotTable Fields pane; keyboard focus on a field checkbox
Excel chooses an area when a field is checked. Review its position instead of assuming every field becomes a value.
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
Navigate to the field list and highlight a field before pressing Space. This is not a worksheet selection command.
Space
Add or remove fields / Add or remove a field from the field list. Microsoft reference ↗
Walk through the operation
- Move focus to the field list and use arrow keys to highlight Amount.
- Press Space once to check the field.
- Press Space again only if you want to remove it.
Instruction 1 of 3: Move focus to the field list and use arrow keys to highlight Amount.
Expected result: The checkbox toggles and the report adds or removes that field in its assigned area.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
Related walkthroughs
- Select an entire PivotTable report
- Clear a focused PivotTable slicer filter
- Group selected PivotTable items
- Ungroup PivotTable items
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.