Interactive Tutorial
Adjust a PivotTable's Layout in Excel
4.9 out of 5 on G2
Practice live in your browser. No software required.
4 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
There are several options for altering the layout of your PivotTable. The Layout group on the Design tab allows you to change what elements appear on the PivotTable.
The Analyze and Design tabs appear under PivotTable Tools on the ribbon.
The Layout group has options to change which elements appear in your PivotTable.
A list of options appears, depending on the button that was selected.
The PivotTable layout is updated based on your selection.