Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
When I drag to add pivot table field, some of my fields defaults to Count
instead of Sum.I have to go and change it every time manually. Also, some fields loses formatting when I add to pivot table and have to reformat by double clicking it.Is there a way to lock formatting and also lock defaulted to sum? Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
regarding the format you should the table the way you want it to appear then
uncheck the "autoformat table" under PivotTable options "Sanj" wrote: When I drag to add pivot table field, some of my fields defaults to Count instead of Sum.I have to go and change it every time manually. Also, some fields loses formatting when I add to pivot table and have to reformat by double clicking it.Is there a way to lock formatting and also lock defaulted to sum? Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
regarding the format you should format the table the way you want it to
appear then uncheck the "autoformat table" under PivotTable options "catrrmg" wrote: regarding the format you should the table the way you want it to appear then uncheck the "autoformat table" under PivotTable options "Sanj" wrote: When I drag to add pivot table field, some of my fields defaults to Count instead of Sum.I have to go and change it every time manually. Also, some fields loses formatting when I add to pivot table and have to reformat by double clicking it.Is there a way to lock formatting and also lock defaulted to sum? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table question | Excel Worksheet Functions | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) |