Top 3 Excel Pivot Table Shortcuts

TOP 3 EXCEL PIVOT TABLE SHORTCUTS

For 2021

ALT SHIFT →

GROUP SELECTED ITEMS

• You can easily group together items in a field!

• Highlighting the items you want to group then press ALT + SHIFT + RIGHT ARROW key.

SHIFT CTRL =

Open Calculated Field Dialog

ALT F5

REFRESH PIVOT TABLE

This is the most handy shortcut!

-John M.