# How to Group Rows in Excel by Name (3 Effective Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

### 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.

## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF