Applies ToExcel for Microsoft 365 Excel for the web Excel 2024 Excel 2021 Excel 2019 Excel 2016

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 design the layout and format of a 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

You can view and interact with the data in PivotTables, but the PivotTable tools you’d need to make changes to the style of the PivotTable aren’t available in Excel for the web. You will need the desktop version of Excel to be able to do that. See Change the style of your PivotTable.

PivotTable on iPad is available to customers running Excel on iPad version 2.82.205.0 and above. To access this feature, please ensure your app is updated to the latest version through the App Store.

  1. Tap anywhere in the PivotTable to show to the PivotTable tab on the ribbon.  PivotTable tab on iPad

  2. Tap PivotTable Styles, and then scroll up in the gallery to see all available styles. 

    PivotTables Styles gallery on iPad

  3. Pick the style you want to use.

  4. If you want to change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells, and lines are displayed, you can design the layout and format of a PivotTable.

Show banded rows for ease of scanning

  1. Tap anywhere in the PivotTable to show to the PivotTable tab on the ribbon. 

    Style Options button on iPad

  2. Tap Style Options > Banded Rows (or Banded Columns).

Style Options dropdown on iPad

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Create a PivotTable to analyze worksheet data

Create a PivotTable to analyze external data

Create a PivotTable to analyze data in multiple tables

Change the data layout of a PivotTable

Add, change, find, or clear conditional formats

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.