In this article we will show you how to group rows in Google Sheets to organize and manage your data in just a few simple steps.
For this example a dataset was created. Click here to access the sample sheet and follow along at home.
Select the rows you need to group. To select multiple rows click on a row number and drag downwards to select the other rows to be grouped.
In this example we clicked on row 5 and dragged down to highlight rows 6 and 7 too.
Right click on any of the highlighted rows.
From the menu that displays click on View more > row actions this will now display a side menu.
Select Group rows… As you can see in our example this menu option reflects our selected rows (Group rows 5-7).
As an alternative to the menu method we can choose to use the keyboard shortcut at this step which can be more efficient.
With the rows selected hold Alt and Shift (Option and Shift for Mac) followed by the right arrow key.
Your selected rows are now grouped. A clear indicator of this is the minus (-) sign with a downward line displayed at the side of the rows.
Clicking on the minus (-) symbol will collapse the row group and change to a plus (+) symbol which will expand the row group if selected.
We hope this article has helped you and given you a better understanding on how to group rows in Google Sheets. You might also like our article on how to remove duplicate rows in Google Sheets and our tutorial on how to limit rows in Google Sheets.
On a side note, we also recommend reading our guide on how to send an email based on a date in Google Sheets to optimize your workflow.
