Quick, clean, and to the point

How to move a pivot table style to another file

Unfortunately, there is no built-in way to move a custom pivot table style to another workbook. However, there is a simple workaround you can follow when you want to use the style again in a different workbook.

Lets take a look.

Here we have the custom pivot table style that has been created and applied to this pivot table. We’d like to use this same style in a different workbook. But when we check the pivot table styles menu, the custom style not listed, and there is no obvious way to import or copy the style.

To make this pivot table style available in another workbook, just follow this simple workaround. First select the entire pivot table. You can use the Select menu on the Options tab of the PivotTable Tools Ribbon. Choose Select, then Entire PivotTable.

Next, copy the pivot table to the clipboard.

Now navigate to the other workbook and create a new blank worksheet. Then paste the pivot table into the new worksheet. The custom style will be be created as you paste.

Check that the custom style is available on the Design of the PivotTable Tools ribbon. You should see the new style in the workbook, highlighted.

Now that the custom style is available in the second workbook, you can remove the pasted pivot table. Just right-click the worksheet and choose Delete.

You can now apply the custom style to your pivot table. Just select any cell in your pivot table, and and apply the style normally.


Related shortcuts

Dave Bruns