How To Unhide All Rows In Excel | Every Hidden Row Back

Hidden rows can make an Excel sheet feel broken. The row numbers jump. Data looks gone. Formulas seem off. Then you waste ten minutes chasing a problem that usually takes less than one minute to fix.

The good news is that Excel gives you more than one way to bring rows back. The best method depends on what caused them to vanish. Sometimes rows were hidden by hand. Sometimes a filter is trimming the view. Sometimes row 1 is hidden, which throws people off because there is no row above it to click. And sometimes the sheet is protected, so the usual commands do nothing.

This article walks through each case in plain steps. You’ll learn the fastest way to unhide every row at once, what to do when only some rows return, and how to spot the settings that make hidden rows look like they are still missing.

How To Unhide All Rows In Excel On The Whole Sheet

If your goal is to reveal every hidden row in one shot, select the entire worksheet first. That tells Excel to work across all visible and hidden row ranges, not just a small section.

1. Open the worksheet that has missing rows.
2. Select the entire sheet by clicking the triangle at the top-left corner, where the row numbers and column letters meet.
3. Go to the Home tab.
4. Open Format in the Cells group.
5. Choose Hide & Unhide.
6. Click Unhide Rows.

That is the broad fix. It works well when someone manually hid rows across different parts of the sheet and you just want the full view back.

You can also right-click any row number after selecting the whole sheet, then choose Unhide. Many Excel users like that route because it is quicker once your hand already lives near the row headers.

If all rows return, you’re done. If not, don’t assume the data is gone. Excel has a few other settings that can make rows look hidden even after you run the unhide command.

Why Rows Still Seem Missing After You Unhide Them

This is the part that trips people up. “Hidden” is not always the real issue. A worksheet can hide rows in different ways, and each one needs a slightly different fix.

Filtered rows

When a filter is active, Excel is not hiding rows in the same way as the Unhide command. It is narrowing the visible list. So if you unhide rows and nothing changes, clear the filter or switch it back to show all records.

Frozen panes

If the top rows stay locked while you scroll, that is not hidden data. Those rows are frozen. Frozen panes don’t remove rows, but they can make the sheet feel cramped or make the visible area look odd. Unfreezing the pane clears that confusion.

Protected worksheet

On a protected sheet, Excel may block changes to row visibility. In that case, the unhide command can be grayed out or it can fail silently. You will need editing permission or the sheet password.

Row height set too low

Rows can also look hidden when the height is set to a tiny value. In that case, unhide may not fix the view. Resetting row height often does.

First row hidden

Row 1 is a special case. Since there is no row 0 above it, the usual click-and-unhide pattern doesn’t feel natural. Excel has a direct workaround for that.

Microsoft’s own steps for hiding or showing rows or columns match the full-sheet method above: select the needed range, then use Home > Format > Hide & Unhide > Unhide Rows.

What Each Fix Solves Before You Start Clicking Around

If you are not sure which problem you are dealing with, this table gives you a fast read. Start with the symptom that matches your sheet, then use the fix in the right column.

Taking Hidden Rows Back In Excel When Row 1 Is Missing

Missing row 1 feels trickier than it is. Since the sheet starts there, you do not have a visible row above it to drag across. That is why many people think the row is gone for good.

There are two simple fixes. The first is to click the row 2 header, right-click it, and choose Unhide. If Excel picks up that row 1 sits directly above it in a hidden state, it will return right away.

If that does not work, use the Name Box next to the formula bar:

1. Click in the Name Box.
2. Type A1.
3. Press Enter.
4. Go to Home > Format > Hide & Unhide > Unhide Rows.

Microsoft also has a separate page on unhiding the first column or row, which is handy when row 1 or column A is the only part that vanished.

This is also a good trick when a workbook comes from someone else and you do not know what they did to the top of the sheet. Jumping straight to A1 lets you target the hidden edge instead of guessing.

How To Unhide Rows Faster With Mouse And Keyboard

If you do this a lot, speed matters. Excel has a few habits that shave off time.

Use the row-number gap

When you see row numbers skip, drag across the numbers on both sides of the gap, right-click, and choose Unhide. This is faster than going through the ribbon when the hidden block is small.

Select the full sheet with one click

The corner button at the top-left of the worksheet is the fastest route when rows are hidden in several places. One click, one unhide command, and you can scan the sheet again.

Try the ribbon search box

On recent Excel builds, typing “unhide rows” into the search box on the ribbon can surface the command right away. That is handy when you know the action you want but do not feel like scanning tabs.

Reset row height after unhiding

If rows come back but look squeezed, select the whole sheet, open Format again, and set a standard row height. That cleans up the view and makes it clear the data is still there.

When Unhide Rows Does Not Work

If the command runs and the sheet still looks wrong, step through these checks in order. This is the shortest route to the real cause.

Check for filters first

Look for dropdown arrows in the header row. If they are there, clear the filter. Filtered rows are not restored by the regular unhide command because Excel treats them as a filtered view, not a hidden row block.

Check for grouped rows

If you see plus and minus buttons on the left edge, the rows may be collapsed in an outline. Click the plus sign to expand the hidden detail rows.

Check worksheet protection

Go to the Review tab and see whether Unprotect Sheet appears. If it does, the sheet is protected. You may need the password or help from the workbook owner.

Check row height

Select the affected rows, then set a normal height such as 15 or 18. A tiny height can mimic a hidden row and make the sheet look empty.

Check freeze settings

On the View tab, use Unfreeze Panes if that command appears. Frozen panes do not hide rows, though they can make the sheet feel like it is ignoring your scroll or trapping you in a cramped section.

A Clean Way To Keep Rows Visible Next Time

Once you get the sheet back in shape, it is worth stopping the same mess from showing up again next week.

Use filters on purpose

If you only need to narrow a list for a moment, filters are cleaner than manually hiding rows. They are easier to reverse, and other people opening the file can spot them at a glance.

Label grouped sections

If you collapse rows in an outline, leave a clear section label nearby. That way nobody thinks data went missing when the plus sign is sitting one inch to the left.

Avoid hiding rows that feed formulas

Hidden input rows can make a workbook hard to trust. If totals, lookups, or charts depend on hidden areas, add a note on the sheet or move those inputs to a clearly named tab.

Protect only after the layout is final

Protection is useful once the worksheet is settled. Before that, it often gets in the way of simple cleanup jobs like unhiding rows, adjusting height, or clearing old filters.

The Method That Works Most Often

If you want one reliable routine, use this: select the whole sheet, run Unhide Rows, clear any filters, then check row height and protection if rows still do not appear. That sequence solves the issue in most workbooks without any hunting around.

Excel is usually not losing your data. It is just showing less of it than you expect. Once you know the difference between hidden rows, filtered rows, grouped rows, and frozen panes, the fix becomes routine instead of annoying.

Send us your feedbackTell us what you thought about this post

⚠Please use a real email you check. If it's fake or mistyped, your message won't reach us and we can't reply — wrong addresses are rejected automatically.

Name *Email *

Your comment *

Quick check — what is …? *

Send feedback