Ungroup Pivot Items in Excel
Ungrouping Pivot Table items restores them to their original individual rows or columns, removing any grouping applied earlier.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Shift + Left Arrow | Command + Shift + J |
What Does This Shortcut Do?
This shortcut removes the grouping of selected Pivot Table items, restoring them to their original structure while keeping the Pivot Table intact.
How to Use the Shortcut
- Select the grouped items in your Pivot Table that you want to ungroup
- Press the keyboard shortcut:
Windows: Alt + Shift + Left Arrow
Mac: Command + Shift + J - The grouped items will be ungrouped and displayed individually
Tips & Best Practices
- Use ungrouping to analyze individual elements after summary analysis
- Useful when you want to reapply different grouping to the same Pivot Table
- Always select only the grouped items to avoid affecting other table data
FAQ
- Q: Can I ungroup multiple grouped fields at once?
- Yes, select all grouped fields and use the shortcut to ungroup them simultaneously.
- Q: Does ungrouping affect Pivot Charts?
- Yes, Pivot Charts linked to the Pivot Table will automatically reflect the ungrouped data.
- Q: Can I undo ungrouping?
- Yes, press Ctrl + Z (Windows) or Cmd + Z (Mac) immediately after ungrouping to revert changes.