
Finding the exact data, you need in a large spreadsheet job can be challenging 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.
Just click the rows or columns you want to group. It can be straightforward 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 rows 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 columns A to C.
After you group them, you will see a negative or minus sign displayed 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 icon. So to expand it again, click that plus sign again.
Also Read: How to Import an Excel Document into Google Sheets
If you set up several groups of rows or columns on your workstation, you don’t need to click the minus plus signs to collapse or expand each one.
Just right-click either the plus or minus sign for a group. After that, click “Expand All Row/Column Groups” or “Collapse All Row/Column Groups.”
One-click will make all of your row or column groups visible or invisible.
When you’re done using groups to view your data better, ungroup rows or columns.
For rows, do the following steps:
And for columns, do these steps:
When you finish ungrouping the rows or columns, the plus and minus signs in the shaded area will disappear.
You can do the same procedure if you know “Microsoft Excel” and Google Sheets. By combining groups of rows and columns, you can generate a clean, functional, and fully automated data layout.
ManilaShaker is a tech media producing insightful and helpful content for our local and growing international audience. Our goal is to create a premier Philippine digital consumer electronics resource that provides the most objective reviews and comparisons globally.