Pivot Tables

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

2 Questions -
How can I preserve the formating in my Pivot table? I
know how to change the formating, but once I move the
fields around or refresh the data, the formating reverts
to the default. I clicked (and unclicked) the PRESERVE
FORMATING button on the Table Options menu window, but it
still reverts to the bad formatting.

Second, how can I have the data lables just read the
column headings instead of SUM OF... or COUNT OF... It's
not as big a deal, but it is pretty annoying to have the
extra label wording out there when it is unneccessary or
potenitally confusing.

Thanks! ~Alicia
 

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

Pivot Table formating 2
Pivot Table formatting 1
Pivot table column help 2
Pivot Tables and Formatting 2
Excel VBA For excel 0
Formatting Charts from Pivots 2
pivot table - keep text wrapped on refresh? 1
Pivot Table Defaults 1

Back
Top