In the РІР‚СљUse functionРІР‚Сњ drop-down menu, choose one of the available options. Next, you have to choose which operation the subtotals should calculate.In the drop-down menu for РІР‚СљAt each change inРІР‚Сњ, select the column that contains data you want to use for the subtotals.In the РІР‚СљOutlineРІР‚Сњ section, click РІР‚СљSubtotalРІР‚Сњ to open the corresponding menu.Select Sort from the menu and sort the entire sheet by the column which contains the data you want to have subtotals of.Now click the РІР‚СљDataРІР‚Сњ tab from the top menu.Open the spreadsheet in which you want to add subtotals.When youРІР‚в„ўre done rearranging the data in your spreadsheet, you might want to add a new set of subtotals. Hopefully, youРІР‚в„ўve managed to remove the subtotals using the guidelines from the previous two sections. Please note that if thereРІР‚в„ўs a field in your pivot table that contains some calculations, you wonРІР‚в„ўt be able to remove the subtotals. In the РІР‚СљSubtotalsРІР‚Сњ section, select РІР‚СљNoneРІР‚Сњ.In the РІР‚СљField SettingsРІР‚Сњ menu, click the РІР‚СљSubtotals & FiltersРІР‚Сњ tab.In the РІР‚СљActive FieldРІР‚Сњ section, click РІР‚СљField SettingsРІР‚Сњ.For older versions of Excel, click the РІР‚СљOptionsРІР‚Сњ tab. In older versions of Excel (Excel 2013 and earlier), youРІР‚в„ўll see the РІР‚СљOptionsРІР‚Сњ and РІР‚СљDesignРІР‚Сњ tabs without the РІР‚СљPivotTable ToolsРІР‚Сњ title above them. It will appear in the top menu, right next to the РІР‚СљViewРІР‚Сњ tab, and will contain two tabs: РІР‚СљAnalyzeРІР‚Сњ and РІР‚СљDesignРІР‚Сњ. This will allow you to access the РІР‚СљPivotTable ToolsРІР‚Сњ menu.Now select a cell in any of the tableРІР‚в„ўs rows or columns.Open the Excel file containing your pivot table.You can do that without deleting the entire pivot table. If youРІР‚в„ўre working with pivot tables in Excel, thereРІР‚в„ўs no need to create a new table only to remove the subtotals. Now click the РІР‚СљClear OutlineРІР‚Сњ option to remove any grouping for that spreadsheet.In the РІР‚СљOutlineРІР‚Сњ section, click the РІР‚СљUngroupРІР‚Сњ drop-down menu.If you donРІР‚в„ўt want to delete the subtotals, but want to remove all groups to further rearrange your data, do the following: This will ungroup all the data in the spreadsheet, effectively removing any subtotal rows you might have there.In the РІР‚СљSubtotalРІР‚Сњ menu, click the РІР‚СљRemove AllРІР‚Сњ button.In the РІР‚СљOutlineРІР‚Сњ section of the top menu, click РІР‚СљSubtotalРІР‚Сњ.Open the Excel spreadsheet you want to edit.Whether you simply want to remove subtotal rows from your spreadsheet or reorganize the entire sheet, the process is basically the same.

Removing Subtotals from Standard Spreadsheets

How to remove subtotals in excel 2000