Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Carry over formatting in pivot
How do you carry over the formatting of your list onto a pivot table?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carry over formatting between linked cells. | Excel Discussion (Misc queries) | |||
Conditional Formatting in Pivot Based on other values in pivot. XL | Excel Discussion (Misc queries) | |||
How can I carry cell formatting in paste link | Excel Discussion (Misc queries) | |||
Is there a way to carry formatting to a different sheet? | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |