How to Hide or Show Rows in Google Sheets

Content
  1. Easiest way to display more rows in Google Docs Spreadsheet
  2. How to Hide Rows in Google Sheets
  3. Show rows in Google Sheets
  4. Finding hidden information in Google Sheets

Easiest way to display more rows in Google Docs Spreadsheet

Spreadsheets help you explore information in different configurations to explore different possibilities. If you use Google Sheets, it will help you hide † You can hide columns or rows of information to see the big picture without that particular element. The downside to using this nifty trick is that you can forget what you’ve hidden and then wonder where it went.

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

Another trick you can try is freezing strings.

How to Hide Rows in Google Sheets

Sometimes you may want to see information in a spreadsheet that is missing some data. In this example, our salespeople are listed from longest to shortest time in the company. We want to see sales figures without the data from the two most recent hires, Allison and Mike. Here’s how to do it.

  1. Open the Google Sheets file as usual.

  2. Select one or more rows by clicking the number in the left column. Here we have selected rows 8 and 9. All data in the row(s) will be highlighted.

  3. With the lines selected, right-click anywhere on the line.

  4. Choose from the menu hide XY rows (X and Y are numbers representing the first and last marked lines, in this case lines 8-9).

  5. You no longer see the selected rows, but you see arrows in the row numbers above and below.

  6. You can now view your spreadsheet without seeing the information in those rows.

Show rows in Google Sheets

When you’re done viewing information with hidden rows, you can easily see them again.

  1. Open the Google Sheets file as usual.

  2. Find the arrows in the numbered column on the left, above and below the hidden rows, and hover over one of the arrows.

  3. When the arrow bar appears, click one of the arrows and the hidden rows will become visible.

Finding hidden information in Google Sheets

Another way to hide data in Google Sheets is through filters. Let’s say your boss shares a Google Sheets file with you and asks you to analyze information that you can’t even find with search. In this example, we’ll skip the “Volume” string. Perhaps this is due to the presence of a filter.

If you see different colors (usually dark gray) and filter information above the columns, and different colors in the numbered column to the left of the rows, you have a filter.

To cancel this condition, just click X on the right side of the filter information panel. Now you should be able to find the “missing” data without any problems.

Leave a Reply

Your email address will not be published.