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

Unhiding all rows in Excel can be a lifesaver when you’re dealing with hidden data. It’s a simple task where you select your worksheet, navigate to the Home tab, and use the Format options to unhide everything. This process will make all rows visible, ensuring you don’t miss out on any important information.

How to Unhide All Rows in Excel

Let’s walk through the steps to unhide all rows in Excel. These steps will ensure that any hidden rows in your worksheet become visible again.

Step 1: Select the Entire Worksheet

First, select the entire worksheet by clicking the triangle where the row and column headers meet.

Selecting the entire worksheet ensures that no hidden rows are left out. This step is crucial since it covers the whole sheet, allowing you to unhide every hidden row at once.

Step 2: Go to the Home Tab

Next, navigate to the Home tab at the top of the Excel window.

The Home tab contains most of the basic functions of Excel, including formatting and visibility options. It’s your go-to place for making quick adjustments.

Step 3: Click on Format

After that, click on the Format button found in the Cells group.

The Format button holds a treasure trove of options for changing how your cells look and behave, including hiding and unhiding rows and columns.

Step 4: Choose Hide & Unhide

From the drop-down menu, choose Hide & Unhide.

This menu contains specific commands that deal with the visibility of rows and columns. It’s the gateway to making sure all your data is visible again.

Step 5: Select Unhide Rows

Finally, select Unhide Rows from the submenu.

Choosing Unhide Rows will instantly reveal any hidden rows in your worksheet. This step completes the process, making all your rows visible.

Once you complete these steps, all previously hidden rows will reappear in your worksheet. You’ll be able to see and work with all your data without any missing pieces.

Tips for Unhiding All Rows in Excel

  • Check for Filters: Make sure no filters are applied, as they might hide rows.
  • Shortcut: Use the shortcut Ctrl + Shift + 9 to quickly unhide rows.
  • Inspect Hidden Rows: Sometimes rows are hidden for a reason. Double-check any hidden data before making it visible.
  • Use Find & Select: The Find & Select feature can help locate hidden rows.
  • Protected Sheets: If your sheet is protected, you might need to unprotect it first to unhide rows.

Frequently Asked Questions

Why can’t I unhide some rows?

Some rows might be hidden because of filters or sheet protection. Remove any filters and check if the sheet is protected.

How do I unhide multiple non-contiguous rows?

You can manually select the rows or use the entire worksheet selection method to unhide all rows at once.

Can I unhide rows in a protected sheet?

No, you must unprotect the sheet first before you can unhide rows.

What if the Format option is grayed out?

This usually means the sheet is protected. Unprotect the sheet to access the Format options.

Is there a way to unhide rows automatically?

Not directly, but you can write a simple macro to unhide rows if needed frequently.


  1. Select the entire worksheet.
  2. Go to the Home tab.
  3. Click on Format.
  4. Choose Hide & Unhide.
  5. Select Unhide Rows.


Unhiding all rows in Excel is a straightforward but essential skill that can save you from missing out on hidden data. By following the steps described, you’ll ensure that all rows in your worksheet become visible, making your data more accessible and easier to analyze. Whether you’re preparing a report, cleaning up your data, or just making sure you haven’t missed anything important, unhiding rows is a handy trick to have up your sleeve.

For those who frequently work with large datasets, knowing how to efficiently manage row visibility can drastically improve your workflow. If you’re new to Excel, consider exploring additional features like filters and conditional formatting, which can also help manage large sheets.

Now that you know how to unhide all rows in Excel, go ahead and put that knowledge to use. And if you have more questions, don’t hesitate to dive deeper into Excel’s extensive help resources. Happy spreadsheeting!