How To Unhide Rows In Google Sheets (Quick Guide)

Unhiding rows in Google Sheets is a simple process that can be accomplished by clicking the up/down caret icon in the previous row. This quick guide will help you understand how to unhide rows effectively. Let’s get started!

If you’ve ever found yourself working in Google Sheets and noticed that some rows were missing, don’t worry – you’re not alone! It’s actually a common problem, but the good news is that it’s easily fixable. Here’s a quick guide on how to unhide rows in Google Sheets.

Unhide Rows Through the Up/Down Caret Icon

The easiest and quickest way to unhide rows in Google Sheets is by clicking on the up/down caret icon that occurs after hiding the rows. Here are the steps you need to follow:

Step 1: Locate the up/down caret icon

Once you’ve hidden the row(s), you’ll see a small up/down caret icon appear in the row number above the hidden rows.

Step 2: Click the caret icon

Now click the caret icon, either the up or down icon. That’s it! Now the caret icons will disappear, and your hidden rows will be unhidden.

Method 2: Unhide Rows With Mouse

You can also unhide the rows with a few clicks on your mouse. Here are the steps you need to follow:

Step 1: Identify the hidden rows

The first step is to identify the rows that are hidden and select the rows before and after the hidden rows. To do this, click and drag your mouse over the row numbers.

Step 2: Unhiding the rows

With the rows selected, left-click on the mouse, and it will bring up a drop-down menu. Select “Unhide rows” from the menu. The hidden rows will now be visible again.


Being able to unhide rows in Google Sheets is an essential skill for anyone working with data in this powerful tool. Whether you’re a beginner or an experienced user, these quick steps can help you quickly unhide any rows you need to access in your sheet.