In this article:

How to Group Rows in Google Sheets (Step-By-Step Guide)

May 8, 2024

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.

How to Group Rows in Google Sheets

For this example a dataset was created. Click here to access the sample sheet and follow along at home.

Step 1: Select the Rows to Group

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.

How to group rows in Google Sheets

Step 2: Group rows Using the Menu or the Keyboard Shortcut

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.

How to group rows in Google Sheets: Menu Method

Step 3: View the Results

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.

How to group rows in Google Sheets: Results

Clicking on the minus (-) symbol will collapse the row group and change to a plus (+) symbol which will expand the row group if selected.

How to group rows in Google Sheets: Collapsed group

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 and try our payment due reminder software as well!

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->