Grouping Rows in Excel-5 Easy Ways
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
- Select the Rows to be grouped
- Go to the Data tab and click Group.
- In the dialogue box, select Rows.
- Press OK. Rows will be grouped together.
- Rows 5, 6, 7 are grouped now.
- Click the minus (-) sign to hide rows.
- Click the plus (+) sign to show rows.
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.
This is the result
Rows 5, 6, 7 from the outer group and Rows 3, 4, 5 from the inner group.
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.
- Click OK.
- Click the minus (-) sign to hide rows.
- Click the plus (+) sign to show rows.
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.
Using SUM Function in each row to get the Total Sales.
Here is the result we get after adding
Go to Data Tab>> Group>>Select Auto Outline
Data will be grouped according to the different Months
Click the plus sign(+) the plus sign to expand the group.
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,
- Dialog Box will appear select the Sort By-Month. Click OK.
- 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.
- Click OK.
- Data will be Grouped.
Download Practice File
Hope you like this article. please subscribe us to learn more Excel Tricks.
