How to Unhide Rows in Google Sheets

By | April 17, 2023

Is your Google Sheets document missing some rows? Don’t panic. Sometimes by accident, we hide the rows and forget how to bring them back. It can be frustrating when you can’t find a particular row that you need. Fortunately, Google Sheets makes it really simple to unhide them.

In this article, we’ll walk you through the steps to unhide rows in Google Sheets. With our guide, you’ll quickly learn how to get your missing rows back in no time.

Why Would You Want to Unhide Rows in Google Sheets?

Hiding selected rows makes your document look neat and presentable, especially when presenting it to an audience. But sometimes we hide rows by mistake, or someone else hides them, and we forget how to unhide them. It can be a challenge to locate these hidden rows, but un-hiding them is easy.

You may also want to unhide rows in Google Sheets because they contain important data that you need to work with. Hiding rows can sometimes inhibit your ability to complete necessary actions on your spreadsheet.

How to Unhide Rows in Google Sheets

If you’ve lost rows in your Google Sheets document, don’t panic. In just a few simple steps, you can quickly get those rows back.

1. Choose the Rows to Unhide

The first step is to select the rows that you want to unhide. To do this, follow the steps below:

  1. Click on the row number above the hidden rows. For example, if you want to unhide rows 5 to 10, click on the number “5” to select it.
  2. Hold the shift key and click on the number “10”. This will select all rows between 5 and 10.

Once you’ve selected the rows that you want to unhide, move on to Step 2.

2. Unhide the Selected Rows

After selecting the rows that are hidden, you just need to right-click on one of the selected rows. This will prompt a drop-down menu. Follow these steps to unhide the rows:

  1. Right-click and select “Unhide Rows” from the drop-down menu.
  2. Google Sheets will automatically bring the hidden rows back into view.

Unhide Rows Using the Menu Bar

If you prefer, you can also use the menu bar to unhide rows in Google Sheets:

  1. Select the rows above and below the hidden rows.
  2. From the top menu bar, click on “Format”.
  3. Click on “Rows”.
  4. Click on “Unhide Rows”.

Unhide Individual Row

If you’re not sure which row is hidden in your spreadsheet, you can also unhide it individually.

  1. Select the row above and below the hidden row.
  2. Right-click and select “Unhide Rows”.
  3. The hidden row will be visible again.

Troubleshooting Unhiding Rows

If you followed the above steps and still can’t unhide rows in Google Sheets, these suggestions may help:

  1. Check for Frozen Panes: If you have any frozen rows or columns in your sheet, then hidden rows cannot be seen. Unfreezing the spreadsheet will allow you to view the hidden rows.
  2. Check for Password Protection: If the rows in your spreadsheet are protected by a password, you’ll need to have the password to unhide them.
  3. Check your Filter Settings: If filter settings are applied in the spreadsheet, the hidden rows may not be visible. Clearing the filter for the rows will allow you to see hidden rows.

If you still can’t unhide rows in Google Sheets, contact Google support for further assistance.


Hiding rows in Google Sheets can make your document look neat and tidy, but it’s easy to forget how to unhide them. Thanks to the simple steps outlined in this guide, you can quickly recover any lost rows in your document.

Just remember to select the rows you want to unhide, right-click, and select “Unhide Rows” or use the menu bar. With this guide, you’re now armed with everything you need to unhide rows in Google Sheets with ease.

Leave a Reply

Your email address will not be published. Required fields are marked *