Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off pivot table subtotals in Excel 2002
Is there a way to turn off the automatic piviot table subtotals in Excel
2002? I can't find it as an option under "field settings subtotals none" as it is in 2003 and later. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off pivot table subtotals in Excel 2002
Hello,
In Excel 2002 you can try this....Click a cell in the list that contains a subtotal. On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed. Click Remove All. When you remove subtotals, Microsoft Office Excel also removes the outline (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.) and any page breaks that you inserted into the list along with the subtotals. "Tim Whitley" wrote: Is there a way to turn off the automatic piviot table subtotals in Excel 2002? I can't find it as an option under "field settings subtotals none" as it is in 2003 and later. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Pivot Table : Can I divide instead of sum ? | Excel Discussion (Misc queries) | |||
Excel 2002 - Pivot Table : Can I edit and modify it ? | Excel Discussion (Misc queries) | |||
Excel 2002 Pivot Table Date | Excel Worksheet Functions | |||
Excel 2002 Pivot Table Protection | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2002 | Excel Discussion (Misc queries) |