Log In

Interactive Tutorial

How to Change Pivot Table Layout

Learn How to Change Pivot Table Layout in Excel to Organize Data and Improve Report Presentation

  • Learn by Doing

  • LMS Ready

  • Earn Certificates

Users love us
4.9 stars out of 5 on G2

4.9 rating 2 students

Try this Course with a Free Trial

Interactive Tutorial

Practice live in your browser. No software required.

Try It Now

Excel Basic to Advanced Course

4 Hour Course Certificate

View Course
How to Change Pivot Table Layout

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.

PivotTable Layout Options

  1. Click any cell inside the PivotTable.

    The Analyze and Design tabs appear under PivotTable Tools on the ribbon.

  2. Click the Design tab on the ribbon.

    The Layout group has options to change which elements appear in your PivotTable.

    • Subtotals: Click to show or hide subtotals, and to specify where to show them.
    • Grand Totals: Click to show or hide grand totals, and to specify whether they appear for rows, columns, or both.
    • Report Layout: Show the PivotTable in compact, outline, or tabular form.
    • Blank Rows: Insert or remove a blank line between each grouped item in the PivotTable.
    Pivottable Layout
  3. Click the Layout button for the element you want to update.

    A list of options appears, depending on the button that was selected.

  4. Select an option from the list.
    Pivottable Layout

The PivotTable layout is updated based on your selection.