How to group rows in Excel – 2 simple methods

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

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

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

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.

First, you’ll want to select your first group of data that you want to be paired 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.

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