Software & Apps Google Drive How to Hide or Unhide Rows in Google Sheets Get a different perspective on your data By Karen Marcus Writer Karen Marcus is a former Lifewire writer who has also written for companies like HP, Intel, IBM, Samsung, and others. our editorial process Twitter LinkedIn Karen Marcus Updated February 25, 2020 Tara Moore / Getty Images Google Drive Sheets Docs Slides Tweet Share Email 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. You can 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. 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, 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. Open your Google Sheets file as you normally would. 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. With the row(s) still highlighted, right-click anywhere in the row(s). 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. You should no longer see the row(s) you selected, but you can see arrows in the numbers of the rows above and below. 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. Open your Google Sheets file as you normally would. Find the arrows in the numbered column to the left, above and below the hidden rows, and hover your pointer over one of them. 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.