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

2 Minutes

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

Supercharge Your Spreadsheets with Lido

🚀 Import data from anywhere and build custom tools and powerful dashboards straight from your spreadsheet. Discover what's possible in our Build Gallery.

Lido is a new spreadsheet built for automation. Trigger emails, slack messages, and more directly from a spreadsheet.