How to group rows in Excel – 2 simple methods

Learn how to group rows in Excel to make your data analysis easier.

The microsoft excel logo on a blue background with rows grouped.

Last Updated on

If you want to learn how to group rows in Excel, you’ve come to the right place.

Grouping in Excel is great for making structured sheets of work that have no blank cells, rows, or columns. Once your data is properly organized it’ll look much clearer, and you’ll be able to do a variety of different things to showcase your data later on. There are a total of two methods that can help you group rows in Excel, and we’ll walk you through both of them in this guide.

So, without any further ado, let’s dive in!

1

How to group rows in Excel using Auto Outline

This first method is great for single levels of information that you have in rows. Rather than you going to the effort of creating groups you can let Excel do it for you.

Step

1

Select the cells

Select any cell from one of the rows that you want to group together.

Step

2

Select the Auto Outline option

Go to the Data tab, and click on the drop down arrow next to the Group option. Then, select Auto Outline.

Learn how to create an auto outline and group rows in Excel.

Your rows should now be grouped together automatically as Excel is able to process where you want groups of rows put together.

How to group rows in Excel to create a customer name.

Once the groups have been created, you can click on the plus or minus symbols to expand or collapse your data so that it’s cleaner to view, and once grouped, there’s loads of other things you can do with your data to make it appear much more eye-catching.

2

How to group rows in Excel manually

You can also manually group rows in Excel, and this can also be done through the Group option.

Step

1

Select the data

First, you’ll want to select your first group of data that you want to be paired together.

Step

2

Group the rows together

Now, go to the Data tab and click on the Group button.

Once you’ve done that, a pop up should come up asking if you’d like to group rows or columns. For this, group we’ll want to use rows, but if you want to group columns, it’s as easy as following these steps, but selecting columns instead of rows.

A screenshot of the "Group" button in Excel, allowing users to conveniently group rows in their spreadsheets.

This will add a bar on the left side of the spreadsheet that’ll span down the rows that you selected previously.

Conclusion

This was everything you needed to know about how to group rows in Excel. Both methods work flawlessly, but we’d recommend using the Auto Outline feature as it does everything quickly and smoothly.

Learn more about Excel and its functions through these helpful guides: