Pivot Table Total

  • Thread starter Thread starter James
  • Start date Start date
J

James

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
 
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.
 
Obvious now! Many thanks Luke.


--
James.


Luke M said:
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!*
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table running % total 1
Counting number of items excluding duplicates. 1
Referencing a pivot tables Grand Totals Column 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot table grand total location 1
Pivot Table - 3
Pivot Table - move Totals column 1
Pivot Table percentages 1

Back
Top