Creating a basic custom PivotTable style in Excel 2010
July 9, 2012 8:00 AM Subscribe
Any good resources for help in creating custom PivotTable styles in Excel 2010?
posted by undercoverhuwaaah to Computers & Internet (4 answers total) 1 user marked this as a favorite
Currently, when putting together a new PivotTable, I go into PivotTable Options --> Display and check Classic PivotTable layout. I then go into the Design tab on the PivotTable ribbon and choose "Clear". This gives me the basic layout I like. I then format the header row by manaully doing Cell Formats on each of the column headers with a fill and a font color.
I'd like to save this as a PivotTable style to avoid the few steps involved in doing this each time I create a new PivotTable, but I can't seem to match this exact style when using the "New PivotTable Style" dialogue box (more specifically, I can't get the cell borders to behave the same way).
Any suggestions? Any way to save current formatting as a style? Any resources for explanations