How to Sort Subtotals in Excel

To arrange data based on subtotals, begin by inserting subtotals into the dataset. After you’ve added subtotals, you can sort the data while preserving its structure and ensuring that related data remains grouped together.

For Example, You’ve the Following data:

To group students and calculate subtotals for each student in Column A, allowing you to sort their marks while retaining all the individual details, make sure your data is sorted based on the column you intend to group (in this case, Column A). Here’s how to do it:

Step 1: Select the Data

Step 2: Go to the Data tab in the Ribbon

Step 3: Click on Subtotal to access the Subtotal window

Step 4: Fill the details

In the Subtotal window, select “Student” as the criterion in the “At each change in” drop-down menu.

Check the box next to “Marks” under the “Add subtotal to” section.

Step 5: Click OK to Apply the Subtotals

Step 6: Preview the Result

Following these steps, you’ll see subtotals generated for each student in Column A. This allows you to sort the marks of each student while preserving the detailed data for each individual.

Sorting and adding subtotals is one of the features of Excel which is important for organizing and summarizing data in a structured manner. In this article, you will see the overview of Sorting and Adding Subtotals to Excel and then will discuss all the steps to perform, allowing you to take control of your datasets and derive valuable insights.