In a large spreadsheet job, it can be hard to find the exact data you need by scrolling endlessly. With the help of Google Sheets, you can associate each row and each column and then collapse and expand them as you wish.
GROUP ROWS OR COLUMNS IN GOOGLE SHEETS
Just click the rows or columns you want to group. It can be very easy just by dragging them. After that, right-click the Group option for the rows or columns you selected. As you can see, we group it from row 1 to 7.
For a selection of columns, simply Right-click or click the arrow on one of the column headers to select the Group option. Here, we group it from column A to C.
After you group them, you will see a negative or minus sign display in a shaded area on the left for the rows. Just click the minus sign to collapse the group.
The minus sign becomes a plus sign. So to expand again, click that plus sign again.
EXPAND or COLLAPSE ALL ROW or COLUMN GROUPS
If you set up several groups of rows or columns on your workstation, you don’t need to click the minus and plus signs to collapse or expand each one.
Just right-click either the plus or minus sign for a group. After that, just click “Expand All Row/Column Groups” or “Collapse All Row/Column Groups.”
It allows you to expand or collapse all of your row or column groups in one quick action.
UNGROUP ROWS or COLUMNS IN GOOGLE SHEETS
When you’re done using groups to better view your data, Just simply ungroup rows or columns.
For rows, do the following steps:
– Select the rows, right-click, and pick the Ungroup option.
– Right-click the plus or minus sign for the row group and pick “Remove Group.”
And for columns, do these steps:
– Select the columns, right-click, and pick the Ungroup option.
– Right-click the plus or minus sign for the column group and pick “Remove Group.”
– Select the columns, click one of the column headers, and pick the Ungroup option.
When you finish ungrouping the rows or columns, the plus and minus signs in the shaded area will disappear.
If you have knowledge in “Microsoft Excel” in addition to Google Sheets, you can do the same thing. You can group rows and columns to create a handy automatic outline for your data.