Updated on November 8, 2021 This article explains how to hide or unhide rows in the desktop version of Google Sheets, which is accessed through a web browser. This instructions do not apply to the Google Sheets mobile app. 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. 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.
How to Unhide Rows in Google SheetsWhen you're done viewing information with some of the rows hidden, it's easy to see them again.
How to Find Hidden Information in Google SheetsAnother 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, click the X on the right side of the bar with the filter information. Now you should be able to find your "missing" data with no problem. Tara Moore/Getty ImagesAnother Trick to Try: Freezing Rows in Google Docs Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe How do you hide a row in Google Sheets?How to Hide Rows and Columns in Google Sheets. Right-click a row or column header.. Select Hide row or Hide column.. Why can't I hide rows in Google Sheets?To hide a row, right click on the row number on the left of the spreadsheet and choose Hide row. To hide multiple rows in a Google Spreadsheet, click on the first row and drag across the rows you wish to hide, or hold the Shift key and click on the last row you want to hide.
How do I hide rows in Google Sheets without a mouse?The process on an Android is similar. Tap and hold the row you want to hide. On the menu that appears above the selected row, tap the three vertical dots and choose "Hide row."
|