Table of Contents
To remove subtotals in Excel, follow these steps:
1. Select the data range that contains subtotals.
2. Go to the “Data” tab in the ribbon.
3. In the “Outline” group, click on “Subtotal”.
4. In the Subtotal dialog box, click on the “Remove All” button.
5. Click “OK” to confirm the removal of subtotals.
This will remove all subtotals from the selected data range. Alternatively, you can also select each subtotal row individually and delete them manually.
Removing subtotals in Excel is useful for simplifying data analysis and presentations, as it eliminates any unnecessary calculations and allows for a clearer view of the data. This feature is especially helpful when working with large datasets or when creating charts and graphs. By following these steps, you can easily remove subtotals and customize your data in Excel.
Remove Subtotals in Excel (With Example)
You can use the Remove All button within the Subtotal function of the Outline group in the Data tab to remove subtotals from a sheet in Excel.
The following example shows exactly how to do so.
Example: How to Remove Subtotals in Excel
Suppose we have the following dataset in Excel that contains information about points scored by basketball players on various teams:
Notice that the dataset currently has subtotal rows to display the total points scored by each team.
To remove these subtotals, highlight the range A1:B17, then click the Data tab along the top ribbon, then click the Subtotal icon within the Outline group:
In the new window that appears, click the Remove All button in the bottom left corner to remove all subtotals and formatting from the dataset:
Once you click this button, all subtotal rows and subtotal formatting will be removed from the dataset:
If you would instead like to keep the subtotal rows but remove the groupings, you can click the arrow next to Ungroup in the Outline group of the Data tab, then click Clear Outline:
The groupings will be removed but the subtotal rows will remain:
Feel free to use whichever method you’d like, depending on whether or not you’d like to remove the subtotals and the groupings or just the groupings.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: