Excel Pivot & Chart Shortcuts

Mini cheat sheet for PivotTables, PivotCharts, and chart creation — densest on Windows ribbon keys. Full list on the Excel shortcuts page (filter: Pivot & charts).

Open the searchable sheet and tap the Pivot & charts chip.
Open full shortcut sheet →

PivotTable shortcuts

Action	Windows	Mac
Insert PivotTable	`Alt`+`N`, `V`	—
Refresh selected / all	`Alt`+`F5` / `Ctrl`+`Alt`+`F5`	`⌘`+`⌥`+`R`*
Group selected pivot items	`Alt`+`Shift`+`→`	`⌘`+`Shift`+`K`
Ungroup pivot items	`Alt`+`Shift`+`←`	`⌘`+`Shift`+`J`
Show Field List	`Alt`+`J`, `T`, `L`	—
Analyze / Design tabs	`Alt`+`J`, `T` / `Y`	—
Insert PivotChart	`Alt`+`N`, `S`, `Z`, `C`	—

Chart shortcuts

Action	Windows	Mac
Embedded chart from selection	`Alt`+`F1`	`Fn`+`⌥`+`F1`*
Chart on new sheet	`F11`	`F11`
Recommended Charts	`Alt`+`N`, `R`	—

* Availability varies by Excel for Mac version. Prefer the ribbon when a key is missing.