Site icon ExcelNotes

How to Change Pivot Table in Outline Form

When you first create a Pivot Table with multiple row items, the default layout for the Pivot Table is Compact Form, which lists all row items in one column and saves more spaces to numeric data. While Outline Form displays subtotals at the top of every group. Please follow steps below to change the Pivot Table to the Outline Form.

Step 1: Click any cell within the Pivot Table;

Step 2: Click "Design" Tab from the Ribbon;

Step 3: Click "Report Layout" in the "Layout" section;

Step 4: Click "Show in Outline Form" from the drop-down list;

Step 5: The Pivot table will change to the Outline form.

Exit mobile version