Table of Contents
The dataset showcases data of a company of different months that sells different electronic products.
Method 1:- Grouping Rows in Excel Using the Group Feature
![7.26 Grouping Rows in Excel](https://www.excelsirji.com/wp-content/uploads/2024/06/7.26-Grouping-Rows-in-Excel.png)
- Select the Rows to be grouped
![7.25 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.25-Grouping-Rows.png)
- Go to the Data tab and click Group.
- In the dialogue box, select Rows.
- Press OK. Rows will be grouped together.
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.3-Grouping-Rows-1024x190.png)
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7_4-Grouping-Rows.png)
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.5-Grouping-Rows.png)
- Rows 5, 6, 7 are grouped now.
- Click the minus (-) sign to hide rows.
- Click the plus (+) sign to show rows.
![7.6 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.6-Grouping-Rows.png)
Method 2 :– Creating Nested Groups for Different Rows
Grouping the Rows for January Month,
- Select the Rows > Go to Data Tab >> Group
- Select Rows in the dialog box.
- Click OK.
![7.8 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.8-Grouping-Rows-1024x398.png)
This is the result
Rows 5, 6, 7 from the outer group and Rows 3, 4, 5 from the inner group.
![7.9 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.9-Grouping-Rows.png)
Method 3 :– Shortcut key to Grouping Rows in Excel
- Select the Rows you want to group
- Press SHIFT + ALT + Right Arrow Key ().
- In the dialog box, select rows.
![7.10 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.10-Grouping-Rows-1024x367.png)
- Click OK.
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7_12-Grouping-Rows.png)
- Click the minus (-) sign to hide rows.
- Click the plus (+) sign to show rows.
![7.13 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.13-Grouping-Rows.png)
Method 4 :– Auto Grouping Rows in Excel
Insert Some Rows to get the Total sale of each Month and use Sum Function to get the total.
![7.29 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.29-Grouping-Rows.png)
Using SUM Function in each row to get the Total Sales.
![7.30 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.30-Grouping-Rows.png)
Here is the result we get after adding
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.32-Grouping-Rows.png)
Go to Data Tab>> Group>>Select Auto Outline
![7.18 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.18-Grouping-Rows-1024x133.png)
Data will be grouped according to the different Months
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.15-Grouping-Rows-1-1024x430.png)
Click the plus sign(+) the plus sign to expand the group.
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.16-Grouping-Rows-002.png)
Method 5 :- Grouping Rows in Excel Using the Subtotal Feature
Select the Month and select sort A to Z. This will sort Months into Order. Here is Step by Step
- Click on Sort,
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.23-Grouping-Rows-1024x494.png)
- Dialog Box will appear select the Sort By-Month. Click OK.
![7.21 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.21-Grouping-Rows.png)
- This will Sort your Data
- Now Select the Data and Go to Data Tab>>Subtotal.
A dialog box will appear
- In At each change in:, select the data of the column in which you want to group rows.
- In Use function: Select SUM.
- In Add subtotal to:, select the column in which the mathematical operation will be performed.
- Check Summary below data.
![](https://www.excelsirji.com/wp-content/uploads/2024/06/7.19-Grouping-Rows-1024x406.png)
- Click OK.
- Data will be Grouped.
![7.24 Grouping Rows](https://www.excelsirji.com/wp-content/uploads/2024/06/7.24-Grouping-Rows.png)
Download Practice File
Hope you like this article. please subscribe us to learn more Excel Tricks.