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. Practice with the free Excel practice test on PracticeTestGeeks (25 questions with answer explanations).
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.
Before jumping into fixes, it helps to understand what's actually happening. Rows get hidden in Excel for a few different reasons:
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.
This is the quickest approach when you want to unhide all hidden rows in a worksheet at once.
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.
If you prefer keeping your hands on the keyboard, Excel's built-in shortcuts make unhiding rows fast:
To unhide all rows at once with the keyboard:
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.
The Format menu gives you more control and is useful when you want to unhide specific rows rather than all of them:
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.
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.
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.
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:
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."
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:
Don't confuse grouped rows with hidden rows — the fix is different for each.
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.
The process is nearly identical on Mac, with one difference — keyboard shortcuts use the Command key instead of Control:
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.
If you regularly work with spreadsheets that have hidden rows, a few habits make life easier:
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.
Interactive Excel resources on PracticeTestGeeks, free to start:
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1–1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
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.
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
What is the maximum number of rows supported in a single Excel 2016 worksheet?
Answer: C. 1,048,576
Excel 2007 and later supports 1,048,576 rows (2^20) per worksheet. The 65,536-row limit applied to Excel 2003 and earlier (.xls format).
How many rows are available in an Excel 2019 worksheet?
Answer: A. 1,048,576
Since Excel 2007, each worksheet supports exactly 1,048,576 rows (2^20).
What equation needs to be typed into cell A3 in order to reflect the outcomes as displayed below?
Answer: B. ="Income Statement "&A1
To combine text with the content of a cell in Excel, the ampersand (&) operator is used for concatenation. The text 'Income Statement ' is enclosed in double quotes, and a space is intentionally included after 'Statement' to ensure proper spacing before the value from cell A1 is appended. This creates a dynamic label that updates if A1's content changes.
The ________refers to a group of cells.
Answer: B. cell range
In Excel, a cell range refers to a collection of two or more cells. These cells can be adjacent or non-adjacent, and a contiguous range is typically denoted by the addresses of its top-left and bottom-right cells separated by a colon (e.g., A1:B5). This grouping allows for operations, formatting, or formulas to be applied to multiple cells simultaneously.
Here's a quick decision guide:
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.