PivotTables · original practice scenario
Ungroup PivotTable items
A Facilities group combines Office and Warehouse; the report now needs the separate locations.
Start here: Windows desktop PivotTable; an item inside an existing group is selected
Start inside the existing group. An ordinary worksheet selection has a different context menu. The Mac binding remains unlisted.
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 context-menu Ungroup action removes PivotTable grouping. It does not delete underlying source records.
Shift+F10,U
Windows / Ungroup data. Microsoft reference ↗
Walk through the operation
- Select an item within the Facilities group in the PivotTable.
- Press Shift+F10, release the keys, then press U.
- Review the resulting item labels before using the report.
Instruction 1 of 3: Select an item within the Facilities group in the PivotTable.
Expected result: The PivotTable presents the ungrouped items again.
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
- Toggle a PivotTable field checkbox
- Group selected 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.