Google Sheets are equipped with several tools that allow better segregation and manipulation of data. Here, we’re going to walk you through how you can group and ungroup rows.
It is useful to group rows when there is lots of data that are related or similar. It allows you to expand the data whenever required and keep it closed at other times. This makes the spreadsheet compact, aesthetically pleasing, and easy to use.
Methods To Group and Ungroup Rows
- By using the Group Rows option from the menu
- By using the keyboard shortcut Alt+Shift+Right Arrow.
- Multilayer grouping
- By using the Remove Group option from the menu.
- By using the Alt+Shift+Left-Arrow keyboard shortcut.
Grouping Method 1: Using the Group Rows option
This method lets you easily group rows as shown below:
Step 1: Select the rows that you want to group
Left-click on the row number in the left column to select it. You should see the entire row get highlighted. Click on a row number, press-hold and drag your cursor down until you’ve selected all the rows you want to group.
Step 2: Right-Click and Select the Group Rows Option From The Menu
Right-click on any one of the cells in the selected rows. In the pop-up menu that appears, select the Group Rows [row nos.] option. For example, if the row numbers selected are 1-5, then the option will appear as Group Rows 1-5.
Left-click on it and you’re done. The selected rows will now contain a line connecting them. A – box alongside indicating that they are expanded. Clicking on it will collapse them showing the next row as first with a + box beside it.
Grouping Method 2: Using the Keyboard Shortcut option
This method is a shorter version of the previous one. It utilizes the keyboard shortcut for grouping.
Select the grouped rows like in Step 1 of Method 1. Press the Alt + Shift + Right-Arrow, you’ll notice the rows getting grouped with the line and ‘–’ button appearing on the left beside the row numbers.
Grouping Method 3: Multilayer grouping
Sometimes, multiple groups of rows need to get grouped for better organization. Multilayer grouping effortlessly solves this problem.
Follow these steps to group multiple layers:
Step 1: Expand all the groups
Left-click on every group to expand it so that every row in all of them is visible.
Step 2: Select the rows and Right-Click
This step is similar to the other methods. Select the desired rows and right-click on a selected row’s cell to bring up the pop-up menu.
Step 3: Click on the Group Rows option
Left-click on the Group Rows [selected row nos.] option to apply the grouping. In the example, the rows are 1-14.
That’s it! The rows will get grouped. You will notice a ‘–’ button to the left of the other – buttons. Click on it to collapse the entire multilayer group. Click on the corresponding + button to expand it.
Ungrouping Method 1: Using the Remove Group option
Ungrouping rows is a very simple process in Google Sheets. You can revert the rows to their original state as and when required with just a few clicks.
Follow these steps to ungroup your grouped rows:
Step 1: Right-Click on the -/+ button
Place the cursor on the desired row’s +/- button on the left of the screen. Right-click on it to bring up the pop-up menu.
Step 2: Click on the Remove Group option
Look for the Remove Group option in the pop-up menu (the second option). Click on it. The row-grouping will be gone.
Ungrouping Method 2: Using the keyboard shortcut option
This method is similar to Grouping Method 2. Follow the row selection procedure just like in the previous methods.
Once done, press the Alt + Shift + Left-Arrow, and you’ll find the grouping disappear.
Grouping and ungrouping rows in Google Sheets should now be very easy for you. Hopefully, this will help you to better organize your data efficiently.