Pivot Table - How to Add and Remove Subtotals

Pivot Table - How to Add and Remove Subtotals

Add and Remove Subtotals by using the Field Settings option on Pivot Table

  1. Right-click on a column heading that you wish to add or remove the subtotal view.




  1. Select Field Settings from the View and follow same procedures above to select Automatic for subtotals or None to remove subtotals

    • Related Articles

    • Shortcut to add or remove a Subtotal within a Pivot Table

      Short Cut to add or remove a Subtotal within a Pivot Table Example - if you wish to remove Total line from the Object column Double Click on the column heading that you wish to remove a subtotal.   The Field Settings option will display. If Automatic ...

    • How to Remove Rows from a Pivot Table

      How to remove rows from a pivot table Click Attachments to see document

    • How to successfully use Subtotals buttons

      I think the Pivot Table is the best way to print reports for Auditors – but if you like to use the main tab for subtotals, below is helpful information. Also - if you will click on the Help button in the Subtotal area - it will take you to ...

    • To save pivot table data to a new spreadsheets:

      To save pivot table data to a new spreadsheets: Right click on the tab for the pivot table. Select Move or Copy Select New Book Check “Create a Copy" Click on OK The pivot table data is now in a new sheet – you can save it as any name. Note – this ...

    • Printing Pivot Table Headings on every page – Office 2010

      Printing Pivot Table Headings on each page – Office 2010   Your Pivot Table spans several printed pages and the page, row and column headings only print on the first page – Follow the instructions below if you want the headings on every page Click on ...