How To Group Rows In Google Sheets

In this tutorial, you will learn how to group rows in Google Sheets.

How To Group Rows In Google Sheets

Grouping rows in Google Sheets allows you to organize and summarize related data.

Row groups can then be expanded and collapsed with a single click to show or hide the data in that group.

This is useful when you want to keep detailed information in the spreadsheet for reference, but want the option to view a more concise dataset.

Here’s an example of what expanded vs collapsed rows look like:

Grouped Rows Expanded:

Grouped Rows Collapsed:

Notice in the screenshots above how much space is saved with the row groups hidden.

You can also achieve a similar result by hiding the rows instead of grouping them, but hiding rows is less versatile as you have to select the exact rows you want to hide each time.

In contrast to hidden rows, grouped rows remain grouped even when the group is expanded, which makes it easy to show and hide these rows quickly without having to select specific rows each time.

Group Rows in Google Sheets

Group Rows in Google Sheets (Quick Answer):
  1. Select the rows you want to group. Note that the grouped rows must be adjacent
  2. Open the Data menu. Scroll down to the Group Rows option and click on it. This option is at the bottom of the menu
  3. The rows you selected are now grouped

If you need more detailed steps, here ya go:

Step 1

First, ensure your data is clean and tidy to easily.

Step 2

To group rows in Google Sheets, simply select the rows you want to group, right-click, select ‘View more row actions’, then select ‘Group rows 4-7’.

In this example, we want to group the male names.

Step 3

Once you pressed it, your rows will be grouped.

This creates a cleaner look with functional expanding data. There is a button on the side for you to expand the data grouped if you want to.

Step 4

Another way to group rows in Google Sheets is to select the rows you want to group, select ‘View’, then select ‘Group rows 4-7’.

Expanding & Collapsing Row Groups

When you group rows in Google Sheets, you’ll see a small minus sign [-] appear to the left of the row numbers:

Click on minus to collapse the group. Then click on the plus sign that takes its place to expand again:

You can also expand and collapse row groups using hotkeys.

Do do this, select a range of rows that includes the group or groups you wish to expand or collapse and use the following keyboard shortcuts:

  • Windows Expand: Alt + Shift + Down Arrow
  • Windows Collapse: Alt + Shift + Up Arrow
  • Mac Expand: Option + Shift + Down Arrow
  • Mac Collapse: Option + Shift + Up Arrow

What About Ungrouping Rows?

It’s also easy to remove row groups you no longer need, but remember that you can always expand the group to view the grouped rows without removing the group.

Removing row groups is much the same as adding them:

  1. Select the rows in the group you want to remove. This can be done easily by collapsing and then expanding the group, which automatically selects all rows in the group
  2. Open the Data menu
  3. Scroll down to the Ungroup Rows option and click on it
  4. Your rows are now ungrouped

Further reading: How To Group Columns In Google Sheets

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to group rows in Google Sheets. Want more? Check out all the Google Sheets Tutorials.