Sometimes when working with a large dataset in a spreadsheet program like Google Sheets, you might want to hide certain rows based on the value of a cell.
This can allow you to pull out the data that you need so you can analyze your data much easier.
In this tutorial, I will show you how to hide rows in Google Sheets based on a cell value.
The easiest way to hide rows based on the value of a cell is to use filtering to only show values that meet certain criteria.
To show you how this is done, I will be using this example data:
In this example, let’s say that I want to only view the rows where the revenue is greater than $700. I can use filtering to hide all the rows where the value of the revenue column is less than $700.
Here is how this is done:
1. Highlight the data range that contains the rows that you want to hide values based on cell values
2. In the top menu select Data>Create a filter
3. You will now see filter buttons have appears in your header row. Click on the filter button for the column that contains the values that you want to filter by. In this example, I am selecting the filter button in the “Revenue” column because I want to hide rows where revenue is a certain value
4. After selecting the filter button you will find options for the different ways that you can filter your cells. You can filter by color, by condition, or by values. In this example, I have selected “Filter by condition”
5. In the Filter by condition option you have many different conditions you can choose from. In my example, I want to hide rows that are less than $700 and only show rows greater than 700, so I have selected “Greater than” as my condition and put 700 into the text field
6. After setting up your conditions select OK
7. You will now see that all rows from your data that did not meet the criteria that you set up in step 5 are now hidden.
Closing Thoughts
Learning to be comfortable with filtering is a very useful skill for all spreadsheet users to know. By learning how to filter you can easily manipulate your data to hide rows where the values of your cells meet certain criteria.
In this tutorial, I have shown you a brief example of hiding the data where the cells were less than a certain number, but you have a ton of other options for ways that you can filter data.
You can filter based on text values, dates, colors, and even based on a custom formula.
Filtering is a fundamental skill of using spreadsheets, so I highly recommend you get comfortable with this.
More Google Sheets Tutorials:
How to Use the FILTER Function