If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table - formatting
Hi Anon,
That option was ticked. Despite that, the formatting changes. -----Original Message----- "akk" wrote in message ... Hi I've created a pivot table. In the layout, i have a field in "Page" option. I view by "all" and format the cells in a certain fashion, say as %. When i select some other option, other than 'all', the formatting done no longer holds good. Is there a way out of this? Thanks On the Pivot Table toolbar click the Pivot Table button and select Options... There you will find an option Preserve Formatting. Check this, and when you then apply your percentage formatting it will stick as you alter the 'view by'. . |
Thread Tools | |
Display Modes | |
|
|