Pivot Table Formatting

How to Format a PivotTable in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Pivot Table Formatting

After creating a PivotTable, you may want to enhance the look of it using styles. By default, the column headings, grand total row, and any filters have a light shading applied to the cells based on the workbook’s theme colors. However, if you don’t like these, there are a variety of other styles to choose from.

Work with Style Options

You can select PivotTable style options that allow you to adjust the format for part of a PivotTable. For example, you can apply special formatting to row headers or make the columns banded.

  1. Click any cell in the PivotTable.
  2. Click the Design tab.
    Format a Pivottable
  3. Select an option from the PivotTable Style Options group.
    • Row/Column Headers: Displays special formatting for the first row or column of the PivotTable.
    • Banded Rows/Columns: Applies a different format to alternate rows or columns.
    Format a Pivottable

Apply a Built-In Style

Excel also has a gallery of built-in styles you can choose from to quickly format a PivotTable.

  1. On the Design tab, select an option in the Styles gallery.
    Format a Pivottable

    The PivotTable Styles group will show a few table styles, but to see the rest, you’ll need to expand the gallery.

The style is applied to the table, changing the borders, shading, and colors.

To remove a Table Style, select Clear from the More PivotTable Styles menu.