Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

Insert PivotTable

Open the Insert PivotTable dialog to create a new pivot table from the selected data.

Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Alt+N+V
 Not available
Word Not available Not available
PowerPoint Not available Not available
Outlook Not available Not available
Teams Not available Not available
Google Workspace
Google Sheets Not available Not available
Google Docs Not available Not available
Google Slides Not available Not available
More in Pivot Tables
Collapse PivotTable Field Expand PivotTable Field Group PivotTable Items Move to Next PivotTable Field Move to Previous PivotTable Field Open PivotTable Field List Open PivotTable Options Refresh All PivotTables Refresh PivotTable Select Entire PivotTable Ungroup PivotTable Items

Popular Functions

Hand-picked function guides that work in both Excel and Google Sheets.

SUMIF Function in Excel & Google Sheets (Syntax + Examples) SUM Function in Excel & Google Sheets (Syntax + Examples + Fixes) FORECAST Function in Excel & Google Sheets FILTER Function in Excel & Google Sheets (Syntax + Examples + Fixes)