| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Total
Hello
Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and it's driving me crazy!! many thanks -- James. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Total
Right-click on the Table, go to "Table Options". Uncheck "Grand total for
rows" and "Grand total for columns". You may also need to change the inidvidual field settings and remove subtotals, if you have those as well. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James" wrote: Hello Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and it's driving me crazy!! many thanks -- James. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Total
Obvious now! Many thanks Luke.
-- James. "Luke M" wrote: Right-click on the Table, go to "Table Options". Uncheck "Grand total for rows" and "Grand total for columns". You may also need to change the inidvidual field settings and remove subtotals, if you have those as well. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "James" wrote: Hello Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and it's driving me crazy!! many thanks -- James. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub total vs Pivot Table | Excel Discussion (Misc queries) | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Row Total | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Sub Total In Pivot Table | Excel Discussion (Misc queries) | |||
Hybrid Mode
