In Google Sheets, grouping rows and columns make your data readable, organized, and presentable.
In the example below, we have the sales team data for each state and each quarter.

We will use this example throughout the guide and explain how to group rows or columns in Google Sheets.
Group Rows in Google Sheets
In our example, we first want to group the sales team data for each state. To do this, follow the below steps:
- Select the rows that you want to group. Make sure to select the entire row by selecting the row numbers on the left edge of the sheet. In our example, we selected rows 4, 5, 6, and 7 – representing our sales team in North Carolina.
Select the rows numbers. - From the View menu, hover over the Group option. From the sub-menu, click on the Group rows 4 – 7 option.
Click on View > Group > Group rows. Alternatively, right-click on the selected data. It will open the context menu. From View more row actions, choose Group rows 4 – 7.
Right-click > View more row actions > Group rows. - You will notice a small white box on the left side of the sheet. It will be attached to a vertical line passing over the rows that were selected for the grouping.
White Small Box on the left side of the grouped rows. - Note that the small white box has a minus sign inside it. If you click on that, it will collapse the grouped rows, and the box icon will change to a plus sign. The grouped rows will expand to their original form if you click the plus sign.
Click on the minus and plus signs. You can follow the same steps to group other rows. After grouping other rows, the sheet should look like this.
State-wise grouped rows.
Group Columns in Google Sheets
Using the same example, we will group the product-wise sales data represented in the columns sections. To do this, follow the below steps:
- Select the columns you want to group. Make sure to select the entire column by selecting the column letters at the top edge of the sheet. In our example, we selected columns E and F.
Select the column numbers. - From the View menu, hover over the Group option. From the sub-menu, click on Group columns E – F.
Click on View > Group > Group columns. Alternatively, right-click on the selected data. It will open the context menu. From View more row actions, choose Group columns E – F.
Right-click > View more row actions > Group columns. - You will notice a small white box with a minus symbol above the grouped columns. It will be attached to a horizontal line passing over the columns that were selected for the grouping.
White Small Box above the grouped rows. If you click on the minus sign, the grouped columns will collapse, and the icon will change to a plus sign.
Click on the minus and plus signs. You can follow the same steps to group other columns.
Quarter-wise grouped columns.