Adding Subtotals in Excel

What is Sorting in Excel?

Sorting is the process of arranging the strings or integers so that they can be placed in ascending or descending order. You can sort a text column alphabetically(A-Z or Z-A) and the number column can be sorted either from largest to smallest or smallest to largest.

What is the purpose of Sorting in Excel?

Sorting helps to organize your data in a specified order. It helps you to easily find, analyze, and present information in a structured manner.

How to Sort Data?

Follow the below steps to sort your data:

Step 1: Select the range you want to sort.

Step 2: Go to the “Data” tab on the Excel ribbon.

Step 3: Click on the “Sort button” in the “Sort & Filter” group.

Step 4: Now you can specify your sorting criteria in the Sort Dialog box.

How to sort data based on Multiple Columns?

Adding additional sorting levels in the Sort Dialog box to arrange data by multiple criteria, provides a more comprehensive organization of your dataset.

How to add subtotals in Excel

Follow the below steps to add subtotals in Excel:

Step 1: Make sure your data is sorted by grouping column.

Step 2: Go to the “Data” tab, click on the “Subtotal” button in the “Outline” group, and Specify the column to use for subtotals.

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.