MS Excel: Pivot Table Shortcuts Windows, Mac, Web
- Fakhriddinbek
- May 7
- 2 min read
Pivot Tables are one of the most powerful features in Excel—essential for summarizing, analyzing, and visualizing large datasets. But navigating, creating, and modifying Pivot Tables can become time-consuming without knowing the right shortcuts.
This article provides a comprehensive list of Pivot Table keyboard shortcuts for Excel 2021 across Windows, Mac, and Excel for the Web—so you can manage Pivot Tables like a pro.
Why Use Pivot Table Shortcuts?
Whether you’re analyzing sales data, budgeting reports, or HR records, using keyboard shortcuts with Pivot Tables can:
Save time when building and modifying reports
Increase precision and avoid menu hunting
Speed up exploration and data insights
Pivot Table Shortcuts Table
Action | Windows Shortcut | Mac Shortcut | Web Excel Shortcut |
Create Pivot Table | Alt + N + V | ⌘ + Fn + F10, then V | Alt + N + V |
Group selected items (dates, numbers, etc.) | Alt + Shift + Right Arrow | ⌘ + Shift + K | Alt + Shift + Right Arrow |
Ungroup selected items | Alt + Shift + Left Arrow | ⌘ + Shift + J | Alt + Shift + Left Arrow |
Refresh Pivot Table | Alt + F5 | ⌘ + Shift + F5 | Alt + F5 |
Refresh all Pivot Tables | Ctrl + Alt + F5 | ⌘ + Ctrl + R | Ctrl + Alt + F5 |
Show PivotTable Field List | Alt + J + T + F | N/A | N/A |
Move to next section in the Field List | Tab | Tab | Tab |
Move to previous section in the Field List | Shift + Tab | Shift + Tab | Shift + Tab |
Select entire Pivot Table | Ctrl + A | ⌘ + A | Ctrl + A |
Drill down into selected cell | Double-click cell | Double-click cell | Double-click cell |
Collapse field | Alt + Shift + - | ⌘ + Shift + – | Alt + Shift + - |
Expand field | Alt + Shift + + | ⌘ + Shift + = | Alt + Shift + + |
Open Grouping dialog | Alt + Shift + G | ⌘ + Shift + G | N/A |
Move field up/down in Row/Column/Value area | Alt + Shift + ↑ / ↓ | N/A | N/A |
Most PivotTable options are available under the “PivotTable Analyze” tab (Alt + J + T on Windows).
Example: Quickly Refresh and Drill Down
To refresh a Pivot Table after updating the data source, press Alt + F5 (Windows) or ⌘ + Shift + F5 (Mac).
To view the underlying data of a total, double-click the number cell to create a new sheet with the raw data.
Conclusion
Pivot Tables are Excel’s analytical powerhouse, and mastering the shortcuts related to them boosts your productivity significantly. Whether you're grouping data, refreshing reports, or navigating the field list—these shortcuts will keep your workflow smooth and efficient.
Comments