How to Hide or Unhide Rows in Google Sheets

The easiest way to show more rows in a Google Docs spreadsheet

A woman is looking intently at her laptop computer.

Tara Moore/Getty Images 

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

Here’s how to hide and unhide rows in Google Sheets, including tips for those situations when you’re tired of playing hide-and-seek with your data.

Another trick you might want to try is freezing rows.

How to Hide Rows in Google Sheets

Sometimes you may want to see spreadsheet information with certain data 'missing.' In this example, our sales people 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 clicking on the number in the left column. Here we’ve selected rows 8 and 9. All the data in the row(s) will 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). 

    Google Sheets is showing a spreadsheet with two rows highlighted and an options menu displayed.
  5. You’ll no longer see the row(s) you selected, but you’ll see arrows in the numbers of the rows above and below. 

    Google Sheets is showing a spreadsheet with two rows hidden.
  6. You can now 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 the arrows. 

    Google Sheets is showing a spreadsheet with two rows hidden.
  3. When the arrow bar appears, click one of the arrows, and the hidden rows will 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 is 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.

Google Sheets is showing a spreadsheet with a filter in place.

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. 

Google Sheets is showing a spreadsheet with all rows visible.