Apply Styles to PivotTable

In order to make PivotTable reports more readable and visual appealing, there is need to apply style of our choice  from eighty-five (85) built-in styles.

This categories in to “Light”, “Medium”, “Dark” plus sixteen (16) combinations of styles options in the PivotTable styles gallery located on the design tab under PivotTable tools.

You can go a step further to modify or even create new PivotTable style for your report if none of existing styles suites the exact format you needed.

Built-In styles

This enables us to easily add format and color to our report using one of the available hundreds built-in PivotTable styles to make it more readable and visual appealing.

To do this in excel 2013: Click any cell on the PivotTable report, go to PIVOTTABLE TOOLS, click on Design tab and choose one from different styles under PivotTable Styles as shown in this screenshot.

Customizing PivotTable Styles

In a situation where you cannot find the style that best fits your format, you may build a custom PivotTable style by either create a new style from scratch or simply duplicate and modify an existing style. This newly created custom styles will be added to the styles gallery but can only be available for use in the current workbook.

Any attempt to use the same custom style in other workbook will require you to copy and temporarily paste the formatted PivotTable somewhere in targeted workbook.

Having pasted the formatted PivotTable on the new workbook, apply the custom style on the existing PivotTable and get rid of the temporarily-pasted PivotTable. The following steps will serve as our guide to:

Duplicate Existing PivotTable style:

  • Click any cell on the PivotTable report, go to PIVOTTABLE TOOLS, click on Design tab
  • Right-click on the PivotTable Style you want to duplicate and click the DUPLICATE from the context menu.

  • Modify PivotTable quick style dialog box appears
  • Rename the new PivotTable style and Click Ok.

  • Now you can modify the style to your choice using modification procedures stated below.

Modify Existing Custom PivotTable style

  1. Click any cell on the PivotTable report, go to PIVOTTABLE TOOLS, click on Design tab
  2. Right-click on the custom PivotTable Style you want to modify and click on MODIFY from the context menu.

3. Modify PivotTable quick style dialog box appears

4. Rename the new PivotTable style if you wish.

5. Select the element you intend to modify in the table element list and click on format button.

6. Do the necessary Font, Border, and Fill setting for the selected element and click Ok to return to where the formatted elements is listed (modify PivotTable quick style dialog)

7. Repeat steps 5&6 to format any other element you want.

8. You can as well set your custom style as the default for this document which is not compulsory. Tick the checkbox to set it as default.

9. Click ok to accept the setting and close the PivotTable quick style dialog box.

Having completed the process, now you can apply the custom style since it will not automatically applied to active pivot table. Ensure the PivotTable remain active, go to PivotTable tools, design tab, and choose the custom under PivotTable style group.

Create New PivotTable Style from Scratch

  • Click any cell on the PivotTable report, go to PIVOTTABLE TOOLS, click on Design tab
  • Click New PivotTable Style at the bottom of the style gallery

  • You can now do the necessary adjustment to your style using the modification procedures discussed earlier.

Set PIVOTTABLE Style as Default

You may wish to maintain your newly created or existing PivotTable style option for all your PivotTable reports without have to be selecting it for each report generated.

All you need to do is to set the particular style as default by simply right-click on the style and set it to default.

Hope this post is helpful?

For more Insight on Microsoft Excel, kindly buy any of my books “Productivity Boosting Aspects of Microsoft Excel” and “PivotTable Recipe” on Kindle Amazon. You can as well subscribe to our newsletter here

Shares 0