Change the style of your PivotTable

If you don’t like the look of your PivotTable after you create it, you can pick a different style. For example, when you have a lot of data in your PivotTable, it may help to show banded rows or columns for easy scanning or to highlight important data to make it stand out.

PivotTable formatted in a different style

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Design, and then click the More button in the PivotTable Styles gallery to see all available styles.

    More button in the PivotTable Styles gallery

  3. Pick the style you want to use.

  4. If you don’t see a style you like, you can create your own. Click New PivotTable Style at the bottom of the gallery, provide a name for your custom style, and then pick the options you want.

    Tip:  If you want to change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells, and lines are displayed, you can change the data layout of your PivotTable.

Show banded rows for ease of scanning

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Design > Banded Rows (or Banded Columns).

    Banded Rows and Banded Columns boxes on the Design tab

More about PivotTables

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×