How to Hide or Unhide Rows in Google Sheets

Get a different perspective on your data

Spreadsheets can help you examine information in various configurations to consider different possibilities. If you use Google Sheets, hiding rows is one of the features that help you do this. Hide columns or rows of information to consider the bigger picture without that particular element visible. The downside of using this handy trick is you may forget what you’ve hidden and later wonder where it went.

Another trick you might want to try is freezing rows.

A woman is looking intently at her laptop computer.
Tara Moore/Getty Images 

How to Hide Rows in Google Sheets

Sometimes you may want to see spreadsheet information with certain data "missing." In this example, the salespeople are listed from the longest to the shortest time with the company. We want to see sales figures without those of the two most recent hires, Allison and Mike. Here’s how to do it. 

  1. Open your Google Sheets file as you normally would. 

  2. Select one or more rows by holding the Shift key and clicking on the numbers in the left column. Here we’ve selected rows 8 and 9. All the data in the row(s) should be highlighted. 

    Google Sheets is showing a spreadsheet with two rows selected.
  3. With the row(s) still highlighted, right-click anywhere in the row(s).

  4. From the menu, select Hide rows X-Y.

    X and Y will be the numbers representing the first and last rows you highlighted. In this case, it represents rows 8-9.

    Hide rows
  5. You should no longer see the row(s) you selected, but you can see arrows in the numbers of the rows above and below.

    Google Sheets is showing a spreadsheet with two rows hidden.
  6. View your spreadsheet without seeing the information in those rows.

How to Unhide Rows in Google Sheets

When you’re done viewing information with some of the rows hidden, it’s easy to see them again. 

  1. Open your Google Sheets file as you normally would.

  2. Find the arrows in the numbered column to the left, above and below the hidden rows, and hover your pointer over one of them. 

    Unhide sheets rows
  3. When the arrow bar appears, click one of the arrows, and the hidden rows become visible.

How to Find Hidden Information in Google Sheets

Another way data can be hidden in Google Sheets is with filters. Say your boss shares a Google Sheets file with you and asks you to run an analysis on information that you just can’t find, even by using the search function. In this example, we’re missing the “Tom” row. It’s possible this is happening because there's a filter in place.

If you see different coloring (usually dark gray) and filter information above the columns, and different coloring in the numbered column to the left of the rows, you’re dealing with a filter. To reverse this condition, simply click the X on the right-hand side of the bar with the filter information. Now you should be able to find your “missing” data with no problem.

Cancel filter