How to Unhide All Rows in Excel: A Step-by-Step Guide

Unhiding all rows in Excel is a common task that can be achieved in a few easy steps. It involves selecting the entire sheet, right-clicking on the row headers, and choosing the ‘Unhide’ option. This will reveal any rows that were previously hidden, making all your data visible again.

Step by Step Tutorial: How to Unhide All Rows in Excel

Unhiding rows in Excel is a simple task that can save you from the frustration of missing data. Here’s how to do it.

Step 1: Select the Entire Sheet

Click on the triangle icon located at the top-left corner of the sheet to select the entire sheet.

Selecting the whole sheet ensures that you don’t miss any rows that need to be unhidden.

Step 2: Right-Click on Row Headers

Right-click on the row headers (the numbers on the left side of the sheet) to open the context menu.

Right-clicking on the row headers allows you to access the ‘Unhide’ option quickly.

Step 3: Choose ‘Unhide’

From the context menu, choose the ‘Unhide’ option to reveal the hidden rows.

Once you click ‘Unhide’, all the rows that were previously hidden will now be visible on your sheet.

After completing these steps, all the rows on your Excel sheet will be visible. This means you can now access and edit any data that was hidden before.

Tips for Unhiding Rows in Excel

  • Always make sure you’ve selected the entire sheet to avoid missing any hidden rows.
  • If you have a large dataset, use the ‘Find & Select’ option to quickly locate hidden rows.
  • Keyboard shortcuts can speed up the process; use Ctrl + A to select the entire sheet.
  • Remember that unhiding rows will not affect your data; it simply makes it visible.
  • Check for any filters that may be applied, as these can also hide rows in your sheet.

Frequently Asked Questions

How do I know if rows are hidden in my Excel sheet?

Hidden rows will have a double line on the row headers instead of a single line. The row numbers will also skip the hidden rows.

Can I unhide specific rows instead of all rows?

Yes, you can select the rows surrounding the hidden rows and then right-click and choose ‘Unhide’ to reveal only the specific hidden rows.

Will unhiding rows disrupt my data or formulas?

Unhiding rows does not alter the data or formulas in any way. It simply reveals what was hidden.

Can I use a keyboard shortcut to unhide all rows?

While there’s no direct shortcut to unhide all rows, you can use Ctrl + A to select the entire sheet and then Alt + H, O, U to unhide the rows.

What if ‘Unhide’ is greyed out in the context menu?

If ‘Unhide’ is greyed out, it means there are no hidden rows within the selection or on the sheet.


  1. Select the entire sheet.
  2. Right-click on row headers.
  3. Choose ‘Unhide’.


Mastering Excel is all about knowing the simple tricks that can make your life easier. Unhiding all rows in Excel is just one of these handy skills that can save you time and frustration. Whether you’re a beginner or an Excel pro, it’s always good to brush up on the basics. Remember, Excel is a powerful tool, but it’s only as effective as the person using it. So, keep practicing and don’t be afraid to explore all the features it has to offer. If you ever find yourself stuck or in need of a quick Excel fix, remember this guide on how to unhide all rows in Excel. Happy spreadsheeting!

Join Our Free Newsletter

Featured guides and deals

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