How to Unhide All Rows in Excel (4 Fast Methods)

You've inherited a spreadsheet and suddenly realize entire chunks of data seem to be missing. Rows that should be there — aren't. Sound familiar? Hidden rows in Excel are one of the most common sources of confusion, especially when you're working with files other people built. The good news: once you know where to look, unhiding them takes seconds.

This guide walks you through four proven methods to unhide all rows in Excel, whether you're dealing with a single stubborn row or hundreds of hidden ones scattered across a large dataset. We'll also cover why rows sometimes refuse to unhide — and what to do about it.

Why Rows Get Hidden in Excel

Before jumping into fixes, it helps to understand what's actually happening. Rows get hidden in Excel for a few different reasons:

• Manual hiding — someone right-clicked and chose Hide, or used a keyboard shortcut
• Grouping — rows are collapsed via the Group feature (look for the small minus icon on the left margin)
• Filtering — rows are hidden because an active filter excludes them
• Row height set to zero — technically hidden but not flagged as such by Excel

The method you use to unhide rows depends on which of these caused the hiding in the first place. We'll cover all of them.

Method 1: Select All and Right-Click (Fastest for Most Cases)

This is the quickest approach when you want to unhide all hidden rows in a worksheet at once.

1. Click the Select All button — the small triangle in the top-left corner where the row numbers and column letters meet. Alternatively, press Ctrl + A.
2. Right-click on any row number in the left margin.
3. Choose Unhide from the context menu.

That's it. Every manually hidden row in the sheet reappears instantly. This method works great as a first pass when you don't know exactly which rows are hidden or how many there are.

One thing to note: this won't reveal rows hidden by a filter. If you notice some rows are still missing after this step, scroll down to the section on filters.

Method 2: Keyboard Shortcut to Unhide Rows

If you prefer keeping your hands on the keyboard, Excel's built-in shortcuts make unhiding rows fast:

• Select the rows around the hidden section — click the row above, hold Shift, click the row below
• Press Ctrl + Shift + 9

To unhide all rows at once with the keyboard:

1. Press Ctrl + A to select the entire worksheet
2. Press Ctrl + Shift + 9

This is the equivalent of the right-click → Unhide approach, just faster if you're a keyboard person. It works identically — manually hidden rows come back, filter-hidden rows don't.

Method 3: Use the Format Menu (Home Tab)

The Format menu gives you more control and is useful when you want to unhide specific rows rather than all of them:

1. Select the rows surrounding the hidden area (select the row above and below the gap)
2. Go to Home tab → Cells group → Format
3. Hover over Hide & Unhide
4. Click Unhide Rows

To unhide all rows via this method, first select the entire sheet (Ctrl + A), then follow steps 2–4. You'll see every hidden row pop back into view.

This approach is especially useful in Excel Online, where the right-click context menu sometimes behaves differently from the desktop version.

Method 4: Use the Name Box to Target a Specific Hidden Row

Sometimes you know exactly which row is hidden — say, row 1 — but you can't select it because it's not visible. The Name Box solves this.

1. Click the Name Box (the field to the left of the formula bar that shows the cell address)
2. Type the address of a cell in the hidden row — for example, A1 if row 1 is hidden
3. Press Enter — Excel selects that hidden cell even though the row isn't visible
4. Go to Home → Format → Hide & Unhide → Unhide Rows

This method is particularly handy for unhiding row 1, which is a common problem. Since there's no row above row 1, you can't use the "select rows above and below" technique — the Name Box workaround bypasses that limitation entirely.

How to Unhide Rows Hidden by a Filter

If you've tried the methods above and rows are still missing, there's almost certainly an active filter on the sheet. Filtered rows look hidden but behave differently — standard unhide commands won't work on them.

Look for the funnel icon on any column header. If you see one, a filter is active. To remove it:

• Go to Data tab → click Clear (in the Sort & Filter group)
• Or go to Data → Filter to toggle the filter off entirely
• Or press Ctrl + Shift + L to toggle AutoFilter on/off

Once the filter's cleared, all rows that were hidden by it reappear. If you only want to show all rows temporarily without removing the filter, click the dropdown arrow on the filtered column and choose "Select All."

Unhiding Grouped Rows

Grouped rows have a small minus (−) button on the left side of the sheet, and numbered buttons at the top-left corner (1, 2, 3…). These rows are collapsed, not hidden in the traditional sense.

To expand them:

• Click the + button next to the collapsed group
• Or click the highest number button in the top-left corner to expand all groups
• Or go to Data → Ungroup → Clear Outline to remove grouping entirely

Don't confuse grouped rows with hidden rows — the fix is different for each.

What If Rows Still Won't Unhide?

Occasionally you'll try everything and rows still refuse to appear. A few things to check:

Row height is set to zero. This mimics hidden rows but isn't flagged as "hidden" by Excel. Select the rows around the gap, right-click → Row Height, and type a value like 15. Or select all rows (Ctrl + A), then right-click → Row Height → type 15 → OK.

Sheet is protected. If the worksheet is protected, you may not be able to unhide rows. Go to Review → Unprotect Sheet. If it's password-protected, you'll need the password.

Workbook is shared or read-only. Some sharing settings restrict what you can change. Check under Review → Share Workbook.

Unhiding Rows in Excel on Mac

The process is nearly identical on Mac, with one difference — keyboard shortcuts use the Command key instead of Control:

• Select all: Command + A
• Unhide rows shortcut: Command + Shift + 9
• Right-click works the same way
• The Format menu is in the same location under the Home tab

If you're working across both platforms, it's worth knowing these small differences. You might also run into questions about this on the MOS (Microsoft Office Specialist) exam, which tests practical Excel skills. If that's on your radar, check out our Excel formulas guide to get comfortable with the full range of tools.

Practical Tips for Managing Hidden Rows

If you regularly work with spreadsheets that have hidden rows, a few habits make life easier:

• Document hidden rows — add a note somewhere on the sheet explaining which rows are hidden and why. Future-you (and your colleagues) will appreciate it.
• Use grouping instead of hiding — grouping makes it visually obvious that data is collapsed. Hidden rows are invisible; grouped rows show the +/− toggle.
• Freeze before hiding — if you're hiding rows for presentation purposes, consider freeze panes instead. It keeps header rows visible while you scroll without hiding data. Learning how to merge cells in Excel or using freeze panes can both help you format spreadsheets more cleanly.
• Check before sharing — if you're sending a spreadsheet to someone, review it for hidden rows. Data you've hidden for your own workflow might be exactly what they need.

Excel's hiding feature is genuinely useful — it lets you declutter a view without deleting data. But it can cause real confusion when the next person doesn't realize data is missing. These methods give you a reliable toolkit for surfacing everything that's been tucked away.

If you want to get more efficient with Excel navigation overall, exploring how to use Excel end-to-end is a solid next step — covering everything from basic formatting to more advanced features like how to create a drop down list in Excel. You can also use Excel Online to practice these techniques in your browser — no desktop app required.

Common Mistakes When Unhiding Rows

Even after reading the steps above, people run into the same snags. Here's a quick reference for the most common mistakes:

Selecting only one row instead of both surrounding rows. When you right-click to unhide, you need to have selected at least the row above and below the hidden section. Selecting just one row doesn't give Excel enough context to know which hidden rows you mean.

Trying to unhide filtered rows with the standard method. Filtered rows don't respond to Ctrl + Shift + 9 or the right-click Unhide option. Always check for active filters first — the funnel icon on a column header is the giveaway.

Forgetting that row 1 needs special handling. Since there's nothing above row 1, you can't select a row above it. Use the Name Box method (type A1, press Enter, then unhide from the Format menu) instead.

Confusing grouped rows with hidden rows. They look similar but require different fixes. Grouped rows have the + / − expand controls; hidden rows don't.

Keeping an eye on the Excel spreadsheet guide best practices — like using consistent row structure and documenting hidden areas — helps prevent these headaches in the first place.

Summary: Which Method Should You Use?

Here's a quick decision guide:

• Want to unhide everything at once? → Ctrl + A, then Ctrl + Shift + 9
• Need to unhide a specific row? → Select surrounding rows, right-click → Unhide
• Row 1 won't unhide? → Name Box → type A1 → Format → Unhide Rows
• Rows still missing after unhiding? → Check for active filters (Data → Clear)
• Rows are collapsed, not hidden? → Click the + button, or use Data → Ungroup
• Nothing works? → Check if row height is zero or sheet is protected

Hidden rows are a normal part of working with Excel — they're useful for decluttering complex spreadsheets. But when you're on the receiving end of a file someone else built, knowing how to surface all the data is an essential skill. Whether you use the keyboard shortcut, the right-click menu, or the Format tab, you've now got four reliable options in your toolkit.