Pivot Table Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi

Try right click on PT>Table Options>de-select Autoformat>select Preserve
Formatting
 
Thanks, that did the trick. I am also having problems with getting rows with
no data to collapse. Any ideas?
 
Back
Top