How to Unhide Rows in Excel (2024): A Step-by-Step Guide

Unhiding rows in Excel is like finding hidden treasure. It’s all there, you just need to know where to look! Simply put, if you’ve hidden some rows in Excel and now you want to bring them back into view, you can do so in just a few clicks. It’s a piece of cake once you get the hang of it!

Step by Step Tutorial to Unhide Rows in Excel

Before we dive into the steps, it’s important to understand that unhiding rows in Excel can help you reveal important data that was previously hidden from view. This can be useful when you’re analyzing large datasets or when you want to make sure you’re seeing the whole picture.

Step 1: Select the Rows

Click on the row numbers on either side of the hidden rows.

When you hide rows in Excel, they don’t disappear forever—they’re just out of sight. To bring them back, you’ll need to select the rows that are immediately above and below the hidden rows. This tells Excel, “Hey, I want to see what’s in between these two!”

Step 2: Right-Click

Right-click on the row numbers you’ve selected.

After selecting the rows, you’ll need to right-click to bring up a menu of options. This is like knocking on Excel’s door and saying, “I need more options, please!”

Step 3: Choose ‘Unhide’

Select ‘Unhide’ from the menu that appears.

Choosing ‘Unhide’ is like telling Excel, “Okay, reveal the secrets!” And just like that, Excel will obey your command and the hidden rows will reappear.

Once you’ve completed these steps, the previously hidden rows will show up, ready to be worked on or examined. It’s like they were never gone!

Tips for Unhiding Rows in Excel

  • If you’re having trouble selecting the correct rows, try zooming in to get a better view.
  • Be careful not to select the entire sheet, or you might unhide rows you didn’t intend to.
  • Use the ‘Undo’ feature if you make a mistake and need to re-hide the rows.
  • If you have a lot of hidden rows, you can unhide them all at once by selecting the entire sheet.
  • Remember that unhiding rows won’t remove any data; it will simply make it visible again.

Frequently Asked Questions

Can I unhide multiple rows at once?

Yes, you can unhide multiple rows at once by selecting multiple row boundaries before right-clicking and choosing ‘Unhide’.

What if ‘Unhide’ is greyed out?

If ‘Unhide’ is greyed out, it means there are no hidden rows between the selections you’ve made.

Can I use a keyboard shortcut to unhide rows?

Yes, you can use the keyboard shortcut Ctrl + Shift + 9 to unhide rows.

Will unhiding rows affect my formulas or data?

No, unhiding rows will not affect your formulas or data, it will simply make them visible again.

What do I do if I can’t find the hidden rows?

If you can’t find the hidden rows, try selecting larger sections of the worksheet. They might be hidden far from your current view.


  1. Select the rows around the hidden rows.
  2. Right-click on the selected rows.
  3. Choose ‘Unhide’ from the menu.


Unhiding rows in Excel is a simple yet powerful tool that can help you manage and analyze your data more effectively. Whether you’re working with a small spreadsheet or a massive dataset, knowing how to unhide rows is an essential skill for any Excel user. Remember, hidden rows don’t mean lost data; they’re just tucked away for the moment, waiting for you to bring them back into the light.

Imagine you’re playing hide and seek with your data, and now you’re “it.” By following these easy steps, you’re guaranteed to find all those sneaky hidden rows. And don’t forget the tips and tricks we covered—they’re like your trusty flashlight in the game of data hide and seek.

So go ahead, unhide those rows and let your data shine! With a bit of practice, you’ll be an Excel wizard in no time, effortlessly managing your spreadsheets like a pro. And if you ever get stuck, just remember that the Excel community is vast and helpful, full of forums and guides to assist you in your spreadsheet adventures.

Happy unhiding!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy