How to Hide or Unhide Rows in Google Sheets GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > Google Apps

How to Hide or Unhide Rows in Google Sheets

Get a different perspective on your data

By Karen Marcus Karen Marcus Writer University of Colorado at Denver Colorado State University Karen Marcus is a former Lifewire writer who has also written for companies like HP, Intel, IBM, Samsung, and others. lifewire's editorial guidelines Updated on November 8, 2021 Reviewed by Jon Fisher Reviewed by Jon Fisher Wichita Technical Institute Jonathan Fisher is a CompTIA certified technologist with more than 6 years' experience writing for publications like TechNorms and Help Desk Geek. lifewire's editorial guidelines Tweet Share Email Tweet Share Email Google Apps Sheets Docs Slides

What to Know

Select the rows in Google Sheets by holding Shift and choosing the row numbers in the left column to highlight the rows.Right-click the highlighted rows. Select Hide rows X-Y to hide the rows. Arrows appear in the left column indicating the hidden rows.Unhide the rows by positioning the pointer over one arrow. In the arrow bar, choose one of the arrows to unhide the rows. 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.

How to Hide Rows in Google Sheets

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. 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, where X and Y represent the numbers of the first and last rows you highlighted. In this example, you choose Hide 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. 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, 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 Images Another Trick to Try: Freezing Rows in Google Docs Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Hide and Unhide Columns, Rows, and Cells in Excel How to Use Google Sheets How to Search in Google Sheets How to Highlight and Find Duplicates in Google Sheets How to Limit Rows and Columns in an Excel Worksheet How to Wrap Text in Google Sheets How to Add, Hide, Freeze, or Remove Columns in Sheets How to Sum Columns or Rows in Google Sheets How to Remove Duplicates in Google Sheets How to Hide Your Tagged Photos on Instagram How to Put a Spreadsheet in Google Slides How to Hide iTunes and App Store Purchases in Family Sharing How to Make a Calendar In Excel How to Hide and Unhide a Slide in PowerPoint How to Delete Facebook Posts in Bulk How to Unhide Apps on an iPhone Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies