How to Hide Rows in Google Sheets (in 3 Easy Steps)

Working on a data-heavy Google sheets and want to hide some rows? Follow the 3 Easy Steps...

Shivam Kumar blogger image
Shivam Kumar
Updated on :

When you are working on a data-heavy spreadsheet, sometimes it can be helpful to hide certain rows to better see the exact information you need to analyze.

Fortunately, Google Sheets makes it easy to do this.

In this tutorial, you’ll learn how to hide rows in Google Sheets based on different parameters.

Ready? Let’s jump into it…

01. How to Hide Rows in Google Sheets on a Computer?

Let’s say, we have a simple sales report containing the sales person’s name, region, sales amount, and percentage of sales.

Here we want to see sales figure without the last 3 salespeople in this list. Here is how we can hide them:

  1. Open the Google Sheets in which you want to hide the row.
sales report table
  1. Press CTRL on keyboard and select all the rows you want to hide (in our case Row number 8,9,10)
Highlight rows google sheets table
  1. Right click the selected rows and select Hide rows option from the context menu that appears.
Hide rows in Google Sheets

That’s it… Your selected rows will get hidden and 2 arrows will appear to signify that there are hidden rows in between.

hidden rows

02. How to Hide Rows in Google Sheets on a Smartphone?

  1. Open the Google Sheets document you want to edit.
  2. Tap and Hold the Row number you wish to hide.
  3. Tap anywhere within the shaded area of the selected rows. It will bring up few option such as, Cut, Copy, Auto-Fill, etc. Click on the three vertical dot icon appearing at the right of option menu.
Hide rows google sheet mobile
  1. Select Hide rows option appearing in the pop-up menu.
Hide rows google sheets android

That’s it…

03. How to Hide Rows Based on Cell Value in Google Sheets?

Sometimes, when you are working on a large dataset you may want to hide rows based on a cell value rather than manually hiding each row.

The most convenient way to hide rows based on the cell value is to use the “filtering” feature that lets you show only those values that meet certain criteria.

Let’s see how this feature work…

For example, let’s say we have a table containing students’ names, marks, and percentages.

marks table

Now, I want to only view the rows where the percentage is greater than 75%. I can use filtering to hide all the rows where the value of Marks percentage is less than 75%.

Here’s how:

  1. Highlight the cell range that you want to filter.
highlight cell range
  1. In the top menu select Data >> Create a Filter
create filter in google sheets
  1. You will now see a filter icon in the top cell of every column in the cell range you selected. Click on filter icon in the column that conatins the values that you want to filter by.

In our example, I am selecting the filter icon in the percentage column because I want to hide rows based on the percentage value.

filter icon google sheets
  1. Now a popup menu will appear where you’ll find different ways to filter your data. You can filter data by color, condition or certain value. In our example; I will go with filter by condition option.
  1. In the filter by condition option, you can choose from many different conditions. In our example, I want to shows only those rows where percentage is greater than 75, so I have slected ‘Greater than’ as my condition and put 75% into the value field.
conditional filter google sheets

That’s it….. As soon as I click ‘OK’, all the rows that do not meet the criteria of filter have been hidden.

Filtered rows


04. Final Thought on Hiding Rows:

Knowing how to hide a row in Google Sheets is quite helpful when you’re working on a data-heavy spreadsheet.

In this tutorial, I’ve explained two different ways to hide rows. You can use any one of the above methods based on your situation & needs.

Leave a Comment