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.
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.
How to Add Time in Google Sheets (The Right Way!)
Percentage Change Formula in Google Sheets (2025 Update)