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.
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.
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.
