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

Maybe
Double click on the field header. De-select, Show Items with No Data
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Peculiar default cell format 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Lose formatting on pivot tables 3
Excel VBA For excel 0
Pivot Table Defaults 1
Link Drop Down with Pivot Table 2
Problem formatting pivot table headers 3
Pivot table column help 2

Back
Top