How to☝️ Group Rows and Columns in Google Sheets

To group rows and columns in Google Sheets, first choose the rows you need to group, right-click on them, pick View more row actions, and select the Group rows option. Next, do the same with columns: highlight the columns to group, right-click on them, choose View more column actions, and select Group column.

Read on to delve into the topic further so you can learn more about how to group rows and columns in just a few seconds. The step-by-step instructions and illustrations below will help you avoid making mistakes at any point during the procedure.

How to Group Rows

Grouping rows in Google Sheets can be extremely helpful if you are working with a large and complex spreadsheet. Let’s take a look at how it’s done.

  1. Select the rows you need to group.
  2. Right-click on the selected rows.
  3. Click on View more row actions.
  4. Pick the Group rows option. 

How to Group Rows in Google Sheets

And that’s it! Here is how it looks when you’ve grouped rows together:

How to Group Rows

The same procedure can be applied to other rows as needed.

Grouped Rows

How to Group Columns

It is also possible to summarize and organize your data by grouping your columns. Let’s see how they can be grouped as well.

  1. Highlight the columns you want to group together.
  2. Right-click on them.
  3. Select View more column actions.
  4. Choose the Group column option. 

How to Group Columns in Google Sheets

Easy-peasy! You have now grouped your columns together.

How to Group Columns

Drilling into the Keyboard Shortcuts

It is also possible to use hotkeys as an alternative method to group rows and columns in Google Sheets.

To group rows and columns using keyboard shortcuts:

  1. Select the rows or columns you need to group.
  2. Press ALT + SHIFT + RIGHT ARROW KEY (Windows) / OPT + SHIFT + RIGHT ARROW KEY (Mac OS), and you will see the desired result.

Keyboard Shortcuts to Group Rows

Piece of cake!

How to Collapse Grouped Rows or Columns

The purpose of collapsing grouped rows or columns is to make it easier to view and work with large amounts of data in a Google Sheets document. When rows or columns are collapsed, all the data in those rows or columns is still present in the sheet, but it is hidden from view. Let’s see how to do it!

To collapse grouped rows or columns, simply click the minus sign beside the group.

How to Collapse Grouped Rows or Columns

Easy as ABC!

Grouped Rows or Columns

How to Expand Grouped Rows or Columns

If you need to see the data you have hidden, you can expand a specific section to view more details.

To expand grouped rows or columns, simply click on the plus sign beside the group.

How to Expand Grouped Rows or Columns

Just like that, the data in the grouped rows or columns will be visible again.

The Data in the Grouped Rows or Columns

How to Create Multiple Layers of Grouped Rows and Columns

By creating multiple layers of grouped rows and columns, you can more easily see and work with your data. As a result of grouping, your spreadsheet will be smaller, making it easier to share and collaborate. Let’s get down to business! 

  1. First, select the rows in the first layer. 
  2. Right-click on them.
  3. Choose View more row actions.
  4. Pick the Group rows option.

How to Create Multiple Layers of Grouped Rows and Columns

  1. Then highlight the columns you need. 
  2. Right-click on the selected columns.
  3. Select View more column actions.
  4. Click on Group columns

The View More Column Actions Option

Repeat the process as needed. It’s that simple! 

Multiple Layers of Grouped Rows and Columns

How to Ungroup Rows and Columns

Ungrouping rows or columns is the process of undoing a previous grouping operation. This can be useful if you want to change the structure of your data. Do the following to ungroup rows or columns: 

  1. Select the grouped rows.
  2. Right-click on the highlighted rows.
  3. Click on View more row actions.
  4. Choose the Ungroup rows option.

How to Ungroup Rows and Columns

  1. Choose the grouped column or columns.
  2. Right-click on them.
  3. Select View more column actions.
  4. Tap on Ungroup column.

Ungroup Column

There you go!

The Data

The hotkeys in Google Sheets can also be used to ungroup rows and columns.

  1. Choose the rows or columns you need to ungroup.
  2. Press ALT + SHIFT + LEFT ARROW KEY / OPT + SHIFT + LEFT ARROW KEY.

How to Ungroup Columns

Congrats! The desired result has been achieved!

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X