Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

Open PivotTable Options

Open the PivotTable Options dialog to configure layout display and data settings.

Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Alt+J+T+T
 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 Insert PivotTable Move to Next PivotTable Field Move to Previous PivotTable Field Open PivotTable Field List 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)