How to group in Google Sheets

You can watch a video tutorial here.

When you have a large amount of data that runs into many rows and columns, you can group either the columns or rows so that the data becomes more manageable. This is also useful when you have subtotals within the sheet and would like to collapse the cells so that only the subtotals are displayed.

Option 1 – Group cells by rows

Step 1 – Select the cells

• Select the rows to be grouped

Step 2 – Create the group

• Go to View > Group
• Select Group rows 2-10 

Step 3 – Group the cells

• Click on the minus sign (-) shown at the top of the group indicator

Step 4 – Check the result

• The selected cells will be grouped
• Click on the plus sign (+) to expand the rows
• Repeat the steps above for each group to be created

Option 2 – Group cells by columns

Step 1 – Select the cells

• Select the columns to be grouped

Step 2 – Create the group

• Go to View > Group
• Select Group columns C-G

Step 3 – Group the cells

• Click on the minus sign (-) shown at the top of the group indicator

Step 4 – Check the result

• The selected cells will be grouped
• Click on the plus sign (+) to expand the rows
• Repeat the steps above for each group to be created