Pivot Table Formatting

J

Jarod

I am having a problem with formatting the cells in a pivot table. Every time
I format the cells, and then change the number in the drop down box, the
formatting goes back to the way it was. How do I fix this?
 
R

Roger Govier

Hi

Try right click on PT>Table Options>de-select Autoformat>select Preserve
Formatting
 
J

Jarod

Thanks, that did the trick. I am also having problems with getting rows with
no data to collapse. Any ideas?
 
Top