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

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.

‍

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.

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.

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