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.
Mac keys and context
Navigate to the field list and highlight a field before pressing Space. This is not a worksheet selection command.
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
- 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.
Expected result: The checkbox toggles and the report adds or removes that field in its assigned area.
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.