How To Hide Rows in Google Sheets

There’s no doubt that Google Sheets is an incredibly useful program, allowing you to view and examine information quickly and produce graphs and charts from your data. If you need to travel or don’t have a central computer that you use, you can still access Google Sheets while you’re on the go. It’s also so simple to share the spreadsheet with team members or others who need to access your work.

But there are more options in Google Sheets than you might think. 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.

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. So 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.

How to Hide Rows 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.

  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.

Google Sheets is a cloud-based program that allows you to build spreadsheets. With it, you can use to access, display, and edit spreadsheets as long as you have internet access. You can also easily share Google Sheets with other people. Once you see how easy it is to hide and unhide rows, you’ll be excited to keep more of your data there. Don’t be afraid to make Google Sheets work for you!

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.