In this article we will show you how to collapse rows in google sheets to organize and manage your data in just a few simple steps.
For the purpose of this demonstration an example data set was created. Click here to access the sample sheet and follow along at home.
In your data select the rows you want to collapse.
If the rows are next to each other you can simply click on the label of the first target row and drag over the other rows.
If the rows are apart from each other then you need to press and hold the Ctrl key (or Cmd key on Mac) down and click the rows separately.
In our example we will collapse the rows of all people with a score less than 50 so we can see only the people with a higher score.
Right click the last selected row label. From the menu select Hide Rows to collapse the rows
The rows are now collapsed, you can now see the selected rows have been collapsed with an indicator appearing next to the row labels showing the double arrow symbol ↕
To show the collapsed rows again, click the double arrow symbol.
We hope this article has helped you and given you a better understanding on how to collapse rows in Google Sheets.
You might also like our article on how you can limit rows in Google Sheets and our tutorial on how to move rows in Google Sheets.
On a side note, we also recommend reading our guide on how to extract a domain from an email in Google Sheets.
