In this article:

How to Collapse Rows in Google Sheets (Step-By-Step Guide)

May 8, 2024

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.

How to Collapse Rows in Google Sheets

For the purpose of this demonstration an example data set was created. Click here to access the sample sheet and follow along at home.

Step 1: Select the Rows to Collapse

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.

How to collapse rows in Google Sheets

Step 2: Right Click and Select Hide rows 

Right click the last selected row label. From the menu select Hide Rows to collapse the rows

How to collapse rows in Google Sheets

Step 3: See the Results

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.

How to collapse rows in Google Sheets

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.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->