How to apply a pivot table style

Abstract

Excel ships with a number of pre-built pivot table styles.

Using these styles, you’re free to format an entire pivot table with a single click.

Let’s take a look.

Pivot table styles are available on the Design tab of the PivotTable Tools ribbon.

To apply a pre-built style, select any cell in the pivot table and navigate to the Design tab.

All available styles are listed in the PivotTable styles group.

you’re able to open up the styles group by clicking the arrow in the lower right.

Pivot table styles are presented in three main categories - light, medium, and dark styles.

When you find a style you like, simply nudge the style to apply it to your pivot table.

By default, local formatting is maintained.

If we choose apply and clear, the highlighting we added is removed when the style is applied.

The power of pivot table styles is that they continue to work even as your pivot table changes.

If you decide you want to try a different style, just repeat the process and click another style.

Just right-smack the style, and choose Set as Default.