Copy PivotTable Style

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
Apply and Clear Formatting
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.

______________________

0 thoughts on “Copy PivotTable Style”

  1. 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

  2. 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

  3. Pingback: Copy Table Style « Excel and Access Blog
  4. 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

  5. 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.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.