Carry over formatting in pivot
 

How do you carry over the formatting of your list onto a pivot table?

Carry over formatting in pivot
 

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.

JeannieB wrote:
How do you carry over the formatting of your list onto a pivot table?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Carry over formatting in pivot
 

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 :-)

"Debra Dalgleish" wrote:

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.

JeannieB wrote:
How do you carry over the formatting of your list onto a pivot table?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Carry over formatting in pivot
 

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.

JeannieB wrote:
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 :-)

"Debra Dalgleish" wrote:


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.

JeannieB wrote:

How do you carry over the formatting of your list onto a pivot table?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com