Yesterday, i created a custom PivotTable Style for a customer, to make it easy to format multiple pivot tables, using their corporate colour scheme.
PivotTable Styles are available in Excel 2010 and Excel 2007, and if you don’t like the existing styles, you can create your own custom styles, and apply those to any pivot table.
Copy Custom PivotTable Styles
Unfortunately, there’s no built in way to copy a custom PivotTable style from one workbook to another.
A while ago, I made this video, to show you a workaround for copying your favourite styles to a different workbook.
Remove Existing Formatting
If you’re applying a built-in or a custom style to a pivot table, you might need to remove any manually applied formatting first.
- Instead of clicking on the PivotTable Style icon, right-click on it.
- Then, click Apply and Clear Formatting
You might need to tidy up the pivot table after you apply the new style, but with Custom Styles you can quickly format your pivot tables, so they have a consistent appearance.
______________________
Dear Debra,
Very useful like always, please add a video on “create a custom pivot table style” as well.
May God bless you. You are doing a great service by spreading knowledge to all
Thanks and regards
Fakhar
Hi,
Thank you for your tutorial. I am trying to create a custom style with alternating color for each column. Somehow I am not able to do it. U have tried the Banded Row option but it does not reflect the alternating colors in the first column.
Can you provide some information on the same?
Thank you and regards,
Vivek
Hi Debra,
I have followed your instructions for copying a custom pivot table style but for some reason the style arrives at the destination workbook modified, i.e., different colours from the copied original. Puzzling…
The other thing is that the style is a dark p-table with light coloured fonts on a worksheet with the same dark fill. When the p-table changes size and takes a smaller area area, the worksheet loses the dark fill in the area previously occupied by the p-table and white patches appear. Dos that make sense? Do you think you can reproduce this on your side? Any ideas as to why this happens?
Thanks,
Caula
Hello,
I have already saved my custome style template for tables in excel, for getting the same custom style in pivots do we have to save it all over again? Or is there any way to copy paste the custom table format to custom pivot format?
Thanks,
Rutika.