How to Unhide Rows in Google Sheets: A Step-by-Step Guide

how to unhide rows in google sheets

Unhiding rows in Google Sheets is a straightforward task that helps you access hidden data quickly. To accomplish this, you’ll need to select the rows around the hidden ones, right-click, and choose the "Unhide rows" option. This article will walk you through each step in detail, ensuring you can easily unhide rows in any of your Google Sheets.

Step by Step Tutorial: How to Unhide Rows in Google Sheets

Unhiding rows in Google Sheets ensures you can see all your data without missing anything. Follow these simple steps to unhide any hidden rows.

Step 1: Open your Google Sheets document

First, you need to open the Google Sheets document that contains the hidden rows you want to unhide.

Make sure you are logged into your Google account and navigate to Google Sheets. Open the specific document from your list or upload it if it’s saved on your computer.

Step 2: Select the rows around the hidden rows

Next, highlight the rows above and below the hidden rows. Click on the row numbers to the left to select them.

For instance, if rows 5 to 7 are hidden, select rows 4 and 8. This selection will allow you to unhide the rows in between easily.

Step 3: Right-click on the selected rows

After selecting the rows, right-click to open a context menu with various options.

This menu includes several useful shortcuts. We are interested in the unhide option right now.

Step 4: Choose "Unhide rows" from the menu

From the context menu, select the option labeled "Unhide rows."

This action will immediately reveal any rows hidden within your selected range. You should now see the previously hidden data.

Step 5: Verify the rows are now visible

Finally, check to ensure that the rows you wanted to unhide are now visible and the data is accessible.

If some rows are still hidden, repeat the process, making sure to select the correct range of rows.

After completing these steps, the previously hidden rows in your Google Sheets document will be visible, allowing you to view and edit the data as needed.

Tips for Unhiding Rows in Google Sheets

  • Shortcut Use: Use the keyboard shortcut Ctrl + Shift + 9 (Cmd + Shift + 9 on Mac) to quickly unhide rows.
  • Check for Filters: Sometimes filters can hide rows, so check if a filter is applied that might be causing rows to be hidden.
  • Multiple Rows: To unhide multiple ranges of rows, you might need to repeat the process for each hidden range.
  • Zoom Out: Zooming out can help you see the hidden rows more easily by showing more of your spreadsheet at once.
  • Sharing: If you’re working in a shared sheet, make sure you have permission to unhide rows, as permissions might restrict some users.

Frequently Asked Questions

How can I tell if rows are hidden in Google Sheets?

Hidden rows will cause a skip in the numbering on the left-hand side of the sheet. For example, if rows 6 and 7 are hidden, the numbering will jump from 5 to 8.

Can I unhide all hidden rows at once?

Yes, you can select the entire sheet by clicking the rectangle in the top-left corner (above row 1 and to the left of column A) and then right-click and select "Unhide rows."

What if the "Unhide rows" option is greyed out?

This typically means your selection does not include hidden rows. Ensure you have selected the correct range.

Do hidden rows affect formulas in Google Sheets?

No, hidden rows do not affect formulas. They still include hidden row data in calculations.

Can I hide and unhide rows using a script?

Yes, Google Apps Script can be used to hide and unhide rows programmatically for more advanced tasks.

Summary of Steps

  1. Open your Google Sheets document.
  2. Select the rows around the hidden rows.
  3. Right-click on the selected rows.
  4. Choose "Unhide rows" from the menu.
  5. Verify the rows are now visible.


Unhiding rows in Google Sheets is a valuable skill for anyone working with large datasets. By following these straightforward steps, you can quickly access any hidden information and ensure your data analysis is complete. Remember, hidden rows can sometimes be overlooked, but with the tips and steps outlined in this article, you are well-equipped to handle them.

For further reading, you might explore other features in Google Sheets such as conditional formatting, pivot tables, and the use of various functions to enhance your data management skills. If you encounter any issues or have further questions, don’t hesitate to consult Google’s support documents or community forums.

By mastering how to unhide rows in Google Sheets, you make sure no data stays hidden, ensuring a comprehensive and accurate understanding of your information. Happy spreadsheeting!