Chat with us, powered by LiveChat

Pivot Table Layout

Adjust a PivotTable's Layout in Excel

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.

FREE Quick Reference

Click to Download