Carry over formatting in pivot

  • Thread starter Thread starter JeannieB
  • Start date Start date
J

JeannieB

How do you carry over the formatting of your list onto a pivot table?
 
If you add number fields to the Row, Column or Report Filter area, they
should keep the formatting from the source data.

If you put the number fields in the Values area they'll have the General
format. You can change the formatting after you add the fields to the
pivot table.
 
I guess I wasn't as clear on my first question. How can I carryover the same
font color or cell shading from my list?

Thank you :-)
 
You can't carry the font or cell colour from the source data to the
pivot table. Perhaps you could add it manually, or record a macro an run
that when needed.
 
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

Pivot Table date format 1
Pivot Table formatting 2
I swapped my CPU, how do I carry over all my programs and settings? 1
Multiple Pivot Tables from Same data source 1
Pivot Table - Currency Format 1
Carry over formatting between linked cells. 3
Filtering data from one pivot table against another 4
Pivot table filter list - listing irrelevant subcategorys 1

Back
Top