How To Unhide Rows In Google Sheets

Google Sheets is an incredibly versatile and powerful tool that hundreds of thousands of people use every day. From managing the budget for a small business to keeping track of a personal fitness routine, Google Sheets can handle it all. However, as with any piece of powerful software, there are bound to be a few features that aren’t immediately obvious. One such feature is the ability to hide and unhide rows.

Whether you’ve hidden some rows and now can’t figure out how to get them back or you’ve inherited a spreadsheet from a coworker, this blog post will guide you on how to unhide rows in Google Sheets. Let’s dive in.

Process to Unhide Rows in Google Sheets

If you’ve hidden rows in your Google Sheets and need to reveal them, the process is quite simple. Here’s how you can do it:

Step 1: Open Your Google Sheet

This might seem obvious, but the first step is to open the Google Sheet where the rows are hidden. You can do this by going to the Google Sheets homepage and selecting the file from your dashboard, or by opening the file directly if you have the link.

Step 2: Identify the Hidden Rows

In Google Sheets, when rows are hidden, there will be a small arrow icon in the row headers on either side of the hidden rows. These arrows indicate where the hidden rows are located.

Step 3: Unhide the Rows

Once you’ve located the arrows indicating the hidden rows, unhiding them is straightforward. Here’s how:

Click on the arrow icon. This will bring up a small dialog box with an option that says Unhide rows. Click on it, and voila! The previously hidden rows will become visible again.

If you have consecutive hidden rows and you want to unhide them all, click on the arrow icon at the beginning of the hidden rows, then hold down the Shift key on your keyboard, and while holding it down, click on the arrow icon at the end of the hidden rows. Finally, right-click and select Unhide rows.

  Click on arrow icon > hold Shift key > click on last arrow icon > right-click > Unhide rows

This process will unhide all rows in between.

Step 4: Save Your Changes

Google Sheets automatically saves all changes, but it’s always a good idea to make sure. To manually save your changes, you can press Ctrl + S on your keyboard.


And that’s it! You’ve now learned how to unhide rows in Google Sheets. This feature can be a lifesaver when working with large, complex spreadsheets, and knowing how to use it effectively can make your work much easier. We hope you found this guide helpful!