Shortcut to add or remove a Subtotal within a Pivot Table

Shortcut to add or remove a Subtotal within a Pivot Table

Short Cut to add or remove a Subtotal within a Pivot Table

  1. Example - if you wish to remove Total line from the Object column





  1. Double Click on the column heading that you wish to remove a subtotal.   The Field Settings option will display.




  1. If Automatic is selected, click on the None option to remove the subtotal from the view.




  1. The Object column will display only one line of totals.



  1. If you wish to add the subtotal in a column, simply select the Automatic option to show columns with subtotals.

    • Related Articles

    • Pivot Table - How to Add and Remove Subtotals

      Add and Remove Subtotals by using the Field Settings option on Pivot Table Right-click on a column heading that you wish to add or remove the subtotal view. Select Field Settings from the View and follow same procedures above to select Automatic for ...

    • How to Remove Rows from a Pivot Table

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

    • Repeat All Item Labels in the Pivot Table - Office 2010 & 2013

      Procedures to Repeat All Item Labels in the Pivot Table - Office 2010 & 2013 (these functions are not available in 2003 or 2007) The Pivot Table View can be customized by utilizing the Pivot Table Tools on the menu. How to add Pivot Table Tools on ...

    • 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 ...