Sometimes, you need to create group rows in Excel by name. It is useful when you use several formulas and need to identify them quickly. Group rows by name make the whole group of rows specified with a single name. This process is beneficial in many cases. This article will mainly focus on how to group rows in Excel by name. I hope you find this article informative and gain much knowledge regarding the group rows issue.
How to Group Rows in Excel by Name: 3 Effective Ways
To group rows in Excel by name, we have found three different ways to do it. The three methods mainly consist of defining name command, name manager, and altering the name in the name box. All of these methods are done by using Excel commands. All of these are fairly easy to understand. To show group rows by name, we take a dataset that includes some country’s product, category, and amount. We need to group the rows and then define them with names.
1. Using Define Name Command from Formulas Tab
Our first method is by using the define name command. The define name command is basically used to define any name. Before defining names, you need to group rows. As you can see we have three sections of the total. So, we need to group them according to their country name. Follow the steps carefully.
Steps
- At first, select the range of cells B5 to G7.
- Then, go to the Data tab in the ribbon.
- After that, from the Outline group, select Group drop-down.
- Then, in the Group drop-down option, select Group.
- After that, a Group dialog box will appear.
- From there, select Rows.
- Finally, click on OK.
- As a result of that, we get our desired rows in a group.
- From there, we can expand or collapse the group using the plus (+) and minus (-) icons.
- After that, we need to shift our focus to defining names.
- Again, select the range of cells B5 to G7.
- Then, go to the Formulas tab in the ribbon.
- After that, from the Defined Names group, select Define Name.
- A New Name dialog box will appear.
- In the Name section, set your preferred name.
- Finally, click on OK.
- As a result, we would see the group rows as named USA in the name box.
Read More: How to Group Rows by Cell Value in Excel
2. Applying Name Manager to Group Rows by Name
Our next method is based on utilizing the Name Manager. By using the Name Manager, you can set a range of cells with a specific name. Here, we need to group rows first. Then, set the name of that group of rows. Follow the steps carefully.
Steps
- At first, select the range of cells B9 to G11.
- Then, go to the Data tab in the ribbon.
- After that, from the Outline group, select Group drop-down.
- Then, in the Group drop-down option, select Group.
- After that, a Group dialog box will appear.
- From there, select Rows.
- Finally, click on OK.
- As a result of that, we get our desired rows in a group.
- From there, we can expand or collapse the group using the plus (+) and minus (-) icons.
- After that, we need to shift our focus to defining names.
- Again, select the range of cells B9 to G11.
- Then, go to the Formulas tab in the ribbon.
- After that, from the Defined Names group, select Name Manager.
- A Name Manager dialog box will appear.
- Then, select the New option.
- After that, the New Name dialog box will appear.
- In the Name section, set your preferred name.
- Finally, click on OK.
- As a result, we would see the group rows named Canada in the name box.
Read More: How to Group and Ungroup Columns or Rows in Excel
3. Use of Name Box to Group Rows by Name
Our last method is based on the use of a name box. You can group your rows in Excel and then set the group rows’ names in the name box. This is the easiest process to proceed with. Follow the steps carefully.
Steps
- At first, select the range of cells B13 to G14.
- Then, go to the Data tab in the ribbon.
- After that, from the Outline group, select Group drop-down.
- Then, in the Group drop-down option, select Group.
- After that, a Group dialog box will appear.
- From there, select Rows.
- Finally, click on OK.
- As a result of that, we get our desired rows in a group.
- From there, we can expand or collapse the group using the plus (+) and minus (-) icons.
- After that, we need to shift our focus to defining names.
- Again, select the range of cells B13 to G14.
- Now, you see the name box where cell B13 is written.
- Change that name box and set France according to our dataset. You can change it according to your dataset.
- After that, press Enter.
- Now, if you select that group of rows, it will show France in the name box.
Read More: How to Group Rows in Excel with Expand or Collapse
Download Practice Workbook
Download this practice workbook.
Conclusion
We have shown three different approaches to group rows in Excel by name. All of these methods are user-friendly and mainly done by using Excel commands. I think you find this article very useful for your future purposes. If you have any questions, feel free to ask in the comment box.