Expand all fields in the Pivot Table
Master this Excel shortcut with our comprehensive guide
Pivot Table Shortcuts
Alt + Shift + →
Option + Shift + →
How to Use This Shortcut
Keyboard Shortcut
Alt + Shift + →
Instructions
1. Select a cell in the Pivot Table
2. Press Alt + Shift + →
3. Expands all grouped items in the field
2. Press Alt + Shift + →
3. Expands all grouped items in the field
Keyboard Shortcut
Option + Shift + →
Instructions
1. Select a pivot table cell
2. Press Option + Shift + Right Arrow
3. Expands all grouped items
2. Press Option + Shift + Right Arrow
3. Expands all grouped items
💡 Pro Tip: Quickly view all underlying data without manually expanding each group.
Quick Actions
More Pivot Table Shortcuts
Alt, N, V
Alt, N, S, T
Alt + H