PivotTable—Change the Layout

Press

To

Ctrl+Shift+* (asterisk)

Select an entire PivotTable.

Alt+Shift+Right Arrow

Group the selected items in a PivotTable field.

Alt+Shift+Left Arrow

Ungroup grouped items in a PivotTable field.

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.