| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Formatting
I am having a problem with formatting the cells in a pivot table. Every time
I format the cells, and then change the number in the drop down box, the formatting goes back to the way it was. How do I fix this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Formatting
Hi
Try right click on PTTable Optionsde-select Autoformatselect Preserve Formatting -- Regards Roger Govier "Jarod" wrote in message ... I am having a problem with formatting the cells in a pivot table. Every time I format the cells, and then change the number in the drop down box, the formatting goes back to the way it was. How do I fix this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Formatting
Thanks, that did the trick. I am also having problems with getting rows with
no data to collapse. Any ideas? "Roger Govier" wrote: Hi Try right click on PTTable Optionsde-select Autoformatselect Preserve Formatting -- Regards Roger Govier "Jarod" wrote in message ... I am having a problem with formatting the cells in a pivot table. Every time I format the cells, and then change the number in the drop down box, the formatting goes back to the way it was. How do I fix this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Formatting
Hi
Maybe Double click on the field header. De-select, Show Items with No Data -- Regards Roger Govier "Jarod" wrote in message ... Thanks, that did the trick. I am also having problems with getting rows with no data to collapse. Any ideas? "Roger Govier" wrote: Hi Try right click on PTTable Optionsde-select Autoformatselect Preserve Formatting -- Regards Roger Govier "Jarod" wrote in message ... I am having a problem with formatting the cells in a pivot table. Every time I format the cells, and then change the number in the drop down box, the formatting goes back to the way it was. How do I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Formatting | Excel Discussion (Misc queries) | |||
| Pivot Table Formatting | Charts and Charting in Excel | |||
| Pivot Table Formatting | Excel Discussion (Misc queries) | |||
| Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
| Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
