Collapse all fields in the Pivot Table

Master this Excel shortcut with our comprehensive guide

Pivot Table Shortcuts Alt + Shift + ← Option + Shift + ←

Alt + Shift + ←

1. Select a cell in the Pivot Table
2. Press Alt + Shift + ←
3. Collapses all grouped items in the field

Option + Shift + ←

1. Select a pivot table cell
2. Press Option + Shift + Left Arrow
3. Collapses all grouped items

💡 Pro Tip: Use to quickly clean up the pivot table view for better readability.

Create a Pivot Table

Alt, N, V

Create a PivotChart

Alt, N, S, T

Open the Pivot Table Fiel...

Alt + H