In this article:

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

April 20, 2025

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

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.

Related Articles

How to Add Time in Google Sheets (The Right Way!)
Percentage Change Formula in Google Sheets (2025 Update)

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages