How to change PivotTable layout

Posted on

To change the layout of a PivotTable click the PivotTable Tools, “DESIGN” tab. To change the way the subtotals are displayed click “Subtotals”. I want to display the subtotals for each column under the column instead of the top, so I’ll click “Show all Subtotals at Bottom of Group”. You can also change how Grand Totals are shown. Here I’m just interested to see the Grand Total per Category so I’ll click “Grand Total” and select “On for columns only”.

How to change PivotTable layout

To add more space between each section, click “Blank Rows” and then “Insert Blank Line after Each item.” Now it’s easier to see each year separately.

You have a number of options for changing the PivotTable design. Click “Report layout” to select between different styles. If you select “Show in tabular form” you see each value in its own cell.