You select the rows, right-click, choose "Unhide," and… nothing. The rows stay stubbornly hidden, and your spreadsheet remains incomplete. This is one of the most frustrating Excel problems because the solution often isn't obvious.
When unhiding rows fails, it's rarely a glitch. Usually, Excel is hiding rows through a method you haven't checked yet — grouping, zero row height, filters, or even a macro running in the background. Each cause requires a different fix.
This guide covers every possible reason rows won't unhide, with step-by-step solutions you can apply right now. You'll learn how to diagnose the exact problem in seconds and get back to your data without guessing.
Why Your Unhide Command Isn't Working
Understanding why the standard unhide method fails is the fastest way to fix it. Here are eight distinct causes, each with a clear fix.
Grouped or Outlined Rows
Excel's grouping feature collapses rows under a single expandable section. The plus (+) and minus (–) icons on the left margin are easy to miss, especially in zoomed-out views or wide spreadsheets.
When rows are grouped, right-clicking and choosing "Unhide" does nothing. You must expand the group first.
Look for small plus (+) icons next to row numbers on the left margin. Image source: www.auditexcel.co.za
Fix: Click the plus icon to expand the group. If you see multiple plus signs, nested groups exist — expand each one. Alternatively, go to the Data tab and click Show Detail or select all rows and choose Ungroup.
Row Height Set to Zero
A row with a height of exactly zero behaves like a hidden row but doesn't respond to the standard Unhide command. This happens when you drag a row boundary too far, or when a macro applies zero-height formatting.
Fix: Select the rows above and below the missing area. Right-click and choose Row Height, then enter 15 (the default). For uncertain locations, select a large range like rows 1 to 50 and set the height for all at once.
Protected Worksheet
Sheet protection prevents structural changes, including unhiding rows. You'll notice the Unhide option is grayed out or simply unresponsive.
Fix: Go to the Review tab and click Unprotect Sheet. If a password is required, you need it from the file creator. If "Unprotect Sheet" is unavailable, check Protect Workbook in the same tab — workbook-level protection can also block changes.
Active Filters
Filters hide every row that doesn't match the current criteria. Filters can be active even when you don't see drop-down arrows — especially if the filtered columns are themselves hidden.
Fix: Go to the Data tab and click Clear to remove all filters. Look for funnel icons in any column header — even a single active filter can hide dozens of rows.
Freeze Panes Blocking Visibility
Freeze panes lock rows at the top of your sheet. If a frozen row ends up hidden, it can't be unhidden until you remove the freeze.
Fix: Go to the View tab, click Freeze Panes, and select Unfreeze Panes. Then try unhiding rows. This is especially important if row 1 or row 2 is missing.
VBA Macros Hiding Rows
Macros can hide rows automatically based on conditions. This is common in shared workbooks where automation scripts manage data visibility.
Fix: Press Alt + F11 to open the VBA editor. Look in Modules or ThisWorkbook for code containing .Rows.Hidden = True. Some macros run automatically on file open (Workbook_Open event) — these may re-hide rows every time you open the file.
Multiple Sheets Selected
When two or more sheet tabs are selected (grouped), many Excel features become limited, including row unhiding. You'll see [Group] in the title bar.
Fix: Right-click any sheet tab and select Ungroup Sheets. The [Group] indicator disappears, and you can unhide rows normally.
Corrupted Workbook
A corrupted file can display rows as missing even when they exist. This is rare but happens after power failures, crashes, or transferring files between incompatible systems.
Fix: Go to File > Open, select your file, click the arrow next to Open, and choose Open and Repair. If that fails, copy all data to a new workbook using Paste Special > Values.
Advanced Troubleshooting for Stubborn Hidden Rows
Use Go To Special to Select Hidden Rows
Press Ctrl + G, click Special, then select Visible cells only. This highlights only the unhidden rows, making it easier to identify hidden areas. Once selected, right-click and choose Unhide.
Force Unhide with a VBA Macro
When every manual method fails, run this macro to unhide every row:
Sub UnhideAllRows()
Rows.Hidden = False
End Sub
Press Alt + F11, click Insert > Module, paste the code, and press F5 to run. Repeat for each worksheet if needed.
Check for Conditional Formatting Tricks
Some conditional formatting rules set font color identical to the cell background, making data invisible. Go to Home > Conditional Formatting > Manage Rules and review any rules that change font color or fill. Custom number formats like ;;; also hide all values — check in Format Cells > Number > Custom.
Scan for Compatibility Issues
Files created in Google Sheets, LibreOffice, or older Excel versions sometimes store row visibility data differently. Save the file as a fresh .xlsx file, or copy everything into a new workbook and test the unhide command again.
Troubleshooting Table
| Cause | Signs to Look For | Quick Fix |
|---|---|---|
| Grouped rows | Plus/minus icons on left margin | Click plus icon or Data > Ungroup |
| Row height = 0 | No hidden row indicator, but rows missing | Select range, set Row Height to 15 |
| Protected sheet | Unhide grayed out, lock icon on status bar | Review > Unprotect Sheet |
| Active filters | Funnel icons in column headers | Data > Clear |
| Freeze panes | Missing rows at top, frozen header visible | View > Freeze Panes > Unfreeze |
| VBA macros | Rows hide themselves after file opens | Check VBA editor for .Rows.Hidden |
| Multiple sheets | [Group] in title bar | Right-click tab > Ungroup |
| Corrupted file | Other display issues or errors | File > Open and Repair |
| Conditional formatting | Data exists but invisible | Manage Rules, check font color |
| Compatibility issues | File from other software | Resave as .xlsx or copy to new workbook |
Preventing Hidden Row Problems
Good habits save hours of troubleshooting. Here's what to do going forward.
Use Clear Grouping Practices
Limit grouping to essential sections only. Add a comment or note indicating where groups start and end — especially in files shared with a team.
Document Protection Passwords
Store sheet and workbook passwords in a secure password manager. If multiple people need access, set up a shared password policy. If your washing machine is also acting up, you might find guidance in our troubleshooting guide for a washer that isn't draining properly.
Review Filters Before Sharing
Clear all filters before sending a file to colleagues. If filters must remain active, add a note in the header row or use cell highlighting to indicate filtering is intentional. For other appliance errors, the troubleshooting steps for a Samsung dishwasher OE code follow a similar logic — check the obvious cause first.
Limit Macro Use for Visibility
If you must use macros to hide rows, include a companion macro to reverse the action. Add a button on the sheet labeled "Show All Rows" so users aren't stuck. Our guide on what to do when your refrigerator compressor is bad takes the same approach — always know how to undo a change.
Save Regular Backups
Use File > Save As with dates or version numbers in filenames. Store at least one backup outside your main folder — on cloud storage or an external drive.
Train Team Members
Share a one-page cheat sheet covering common unhiding issues — grouping, filters, and row height. A five-minute overview can prevent hours of confusion. The same principle applies to understanding how your appliances work, like learning what an auto-defrost refrigerator does.
Common Mistakes Even Advanced Users Make
- Checking filters but not grouping. Both can be active at once. Fixing only one leaves rows hidden.
- Assuming hidden means hidden. Zero row height looks identical to hiding but requires different treatment.
- Forgetting about workbook-level protection. Sheet protection is obvious; workbook protection hides in a separate menu.
- Ignoring VBA in shared files. Macros run silently and can re-hide rows every time you open the file.
Real-World Examples
Shared Budget Report
Rows 20–40 were missing in a company budget file. The Unhide command did nothing. Checking the left margin revealed a small plus (+) icon at row 19 — grouping was active. One click restored all rows.
Imported Google Sheets File
An imported sales report had rows that appeared blank but weren't technically hidden. Checking row height showed values of zero. Selecting the entire sheet and setting row height to 15 restored all data instantly.
Macro-Controlled Sales Report
A weekly report hid rows where sales were zero. Normal unhide commands failed because a macro ran on file open. Opening the VBA editor revealed a Worksheets("Sheet1").Rows.Hidden = True line triggered by a data refresh. Running a reverse macro fixed the problem.
When to Seek Professional Help
If you've tried every method here and rows still won't unhide, the workbook may be deeply corrupted. Advanced protection at the workbook level or encrypted VBA projects require specialized tools.
Contact your IT department or an Excel consultant. Never use online password-cracking tools — they can compromise sensitive data. If you're also dealing with other home or office issues, knowing the signs of a bad refrigerator compressor follows a similar diagnostic approach — start with the most likely cause.
Frequently Asked Questions
Why is the Unhide option grayed out?
Your sheet is likely protected or you have multiple sheets selected. Unprotect the sheet from the Review tab, or right-click a sheet tab and select Ungroup Sheets. Microsoft's official Excel support page covers additional scenarios in detail.
Can hidden rows affect my formulas?
Yes. SUM includes hidden rows. Use SUBTOTAL with function number 109 to exclude hidden rows, or AGGREGATE for more control over which values to include.
How do I know if a macro is hiding my rows?
Press Alt + F11 to open the VBA editor. Browse Modules and ThisWorkbook sections for code containing .Rows.Hidden = True. Macros stored in the Workbook_Open event run automatically when the file opens.
Rows stay hidden even after clearing filters. Why?
Multiple methods can hide rows simultaneously. Check for grouping, zero row height, freeze panes, and conditional formatting — you may need to fix more than one issue.
Where can I learn more about Excel troubleshooting?
Start with the Microsoft Support page for Excel, which covers official commands and features. For deeper issues, Excel forums and certified Microsoft trainers provide reliable guidance.
Conclusion
Unhiding rows in Excel stops working when the Unhide command isn't addressing the actual cause. Whether it's grouping, zero row height, filters, protection, or macros, each problem has a clear fix once you know what to look for.
Check grouping first — it's the most overlooked cause. Then move through row height, filters, freeze panes, and protection. For persistent problems, run the VBA unhide macro or repair the workbook.
With these solutions at hand, you'll resolve hidden row issues in minutes instead of wasting time guessing. Your data is there — you just need the right method to reveal it.