Written by Emilija Google Workplace / Sheets
When you have a lot of data on your hands in a large Google sheet, sorting the data in groups can help you get a more organized and concise document.
Creating a group of data in Google Sheets can be done by grouping rows and columns.
With this method, users can group sufficient data and create a document that is much easier to read, then ungroup it with just one click when they need the hidden data again.
The feature for group rows and columns is not new, but it can be tricky for users unfamiliar with Google Sheets.
So, to understand the feature better and learn how to group rows and columns, keep on reading.
Additionally, if you are a frequent Google Sheets user you might find helpful our article about how to insert Google Sheets special characters.
This way the spreadsheet shows only the ungrouped data, and you will see a gray square with a plus sign.
Note: can also use ALT+SHIFT keyboard shortcuts if you are looking for a faster way to group rows.
You might be also interested in reading how to unhide rows in Google Sheets.
To ungroup rows, first click on the gray square with the plus sign. The row groups will be selected by default. Right-click on the group, choose View more row actions, select ungroup 3-7.
This is how Google Sheets group rows feature works.
To ungroup columns first click on the gray square with the plus sign. The column rows will be selected by default. Right-click on the groups, choose View more row actions, select ungroup A-C.
In case you want to create multiple layers of groups you can do so by following the steps below.
When you click on the gray square, the columns and rows will expand and collapse as they do with just one layer.
If you are interested in learning more about Google Sheets, check out our guide on how to indent text in Google Sheets.