How To Hide Rows in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to hide rows in Google Sheets.

How To Hide Rows in Google Sheets

Sometimes you might need to hide rows or columns to help you view your data more clearly.

If you are using Google Sheets and need to hide some of your data temporarily, there’s a trick you can use to hide rows.

Hiding rows does not delete your data. It just temporarily takes it out of view.

How to Hide a Row in Google Sheets

Hiding rows is very easy to do.

It doesn’t even take that many steps to hide rows in Google Sheets.

Remember: you won’t lose any of the data in the hidden rows. They will just be out of sight until you’re ready to unhide them.

Simply right click on the rows you want hidden and select Hide rows:

Alternatively, you can also use this method:

  1. Click on the grey number box of the row you want to hide.
  2. Press the shift key and select the grey number box of the last row you want to hide. Doing this will highlight all the rows you want to hide.
  3. Right-click anywhere on the highlighted rows.
  4. A menu will come up. Select Hide Rows A-B. When you see the menu, it will have the numbers of the rows you want to hide.
  5. The rows will immediately disappear. You will see arrows in the numbers above and below the area you hid rows.

By hiding the rows, you will be able to view the data as you need to without losing anything you put into your Google Sheet. Hiding rows is very easy to and very easy to undo.

Why Would I need to Hide Rows?

There are many reasons you may need to hide rows temporarily.

For example, say you have a sheet covering data over one year. Let’s say you want to look at the data and compare March to June.

You could have so much information in there that it becomes annoying to scroll up and down continually. By hiding the rows, keeping March and June right below one another, it makes it easier for you to do your work.

Other times you may just want to hide rows to see how it changes numbers or performance measurements.

For example, if you’re going to evaluate the performance of some employees, but you recently hired two new employees, you may not want their information to mess up your statistics.

You can hide their data and quickly look at what you need to make calculations.



In this tutorial, I covered how to hide rows in Google Sheets. Want more? Check out all the Google Sheets Tutorials.