If Excel’s Unhide Rows command does nothing, first select the rows on both sides of the missing section and choose Home > Format > Hide & Unhide > Unhide Rows. If the rows remain missing, check whether a filter is hiding them, their row height is zero, the rows are grouped, or the worksheet is protected. These checks work in Excel for Microsoft 365 on Windows; the same ribbon commands are generally available in Excel for Mac, while Excel for the web may arrange some controls differently.
What You’ll Need
- The workbook open in Excel, with the affected worksheet selected.
- Permission to change the worksheet. If it is protected, you may need the password or help from the workbook owner.
- For a shared or important workbook, consider making a copy before changing its layout.
Step-by-Step
- Select the rows around the gap. Look at the row numbers along the left edge of the sheet. If the numbering jumps from 8 to 13, rows 9 through 12 may be hidden. Click row 8, hold Shift, and click row 13 to select both boundary rows and the rows between them. Right-click a selected row number and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows. Selecting the surrounding rows matters: choosing only a visible row elsewhere on the sheet will not reveal the missing section.
- Use the Name Box if the gap is hard to select. The Name Box is to the left of the formula bar. Click it, enter a full-row range such as
8:13, and press Enter. Then choose Home > Format > Hide & Unhide > Unhide Rows. Replace the example range with the rows immediately above and below your hidden rows. This method is useful when many rows are missing or the sheet is zoomed out. - Unhide every row on the worksheet. To reveal all manually hidden rows, click the Select All button at the top-left corner of the grid, where the row and column headers meet. Then choose Home > Format > Hide & Unhide > Unhide Rows. In some layouts, Ctrl+A selects the current data region first; pressing it again may select the whole sheet. The Select All button is the more predictable choice. This action changes row visibility throughout the active sheet, so use it only if revealing every row is acceptable.
- Check whether a filter is hiding the rows. A filter hides records that do not match the selected criteria; Unhide Rows does not override that. Look for filter arrows in the header row and for row numbers that skip while a filter is active. Open the relevant column’s filter arrow and choose Clear Filter for that column, or use Data > Sort & Filter > Clear to clear filters on the sheet. In a formatted table, clear the filter from the table’s column arrow. The filter arrows can remain visible after the hidden records return.
- Set a usable row height. A row with a height of zero can look hidden even when the usual unhide command does not solve the problem. Select the missing rows by entering their range in the Name Box, then choose Home > Format > Row Height. Enter a positive value, such as 15, and select OK. You can also select the rows above and below the gap, right-click a selected row number, choose Row Height, and enter a positive value. If text is still hard to see, try a larger height or use Home > Format > AutoFit Row Height.
- Expand a grouped or outlined section. Grouped rows are collapsed rather than hidden in the ordinary sense. Look to the left of the row numbers for outline controls, such as a plus sign or numbered outline levels. Click the plus sign beside the collapsed section to expand it. You can also select a cell in the group and choose Data > Outline > Show Detail when that command is available. If the outline controls are missing, check Data > Outline for the sheet’s outline options.
- Check worksheet protection. Protection can prevent changes to row formatting and visibility. Open Review and look for Unprotect Sheet. If Excel asks for a password, you need the password or assistance from the workbook owner; do not try to bypass the protection. Once the sheet is legitimately unprotected, try the Unhide Rows command or set the row height again. A protected workbook structure is different from a protected worksheet, so if sheet controls remain unavailable, ask the owner what restrictions are applied.
- Confirm the rows are genuinely back. Check the row numbers and the contents in the formerly missing range. If the numbers are now consecutive but the cells look blank, the rows may be empty, their text may be formatted to blend into the background, or a formula may return an empty string. Click a cell in the area and inspect the formula bar. If the rows still do not appear, continue with the troubleshooting checks below rather than repeatedly selecting Unhide.
Common Mistakes
Selecting only the visible row above or below the gap: Excel needs the hidden rows included in the selection, or both boundary rows selected. If the gap is large, enter a range that covers it in the Name Box instead of trying to drag across row headers.
Confusing a filter with manual hiding: Unhide Rows changes row formatting, while a filter temporarily removes nonmatching records from view. Clear the filter criteria to bring those records back. Avoid turning off filters as your first response if you need to preserve the filter setup; clearing its criteria is often enough.
Using AutoFit as the only fix: AutoFit adjusts a row’s height to its contents, but it does not clear a filter, expand a group, or remove sheet protection. Diagnose the cause first, then use Row Height or AutoFit where appropriate.
Expecting Undo to restore every visibility change: Excel’s undo history can be affected by other actions, and some changes made by macros cannot be undone with Ctrl+Z. Keep a copy of important workbooks before making broad layout changes or running code.
Tips
- When just one small gap is involved, unhide that range rather than revealing every row. This preserves intentional hidden sections elsewhere.
- Use the row numbers as clues: a jump can indicate hidden rows, but filtered lists and collapsed outlines can also create gaps. Check the filter arrows and outline symbols before deciding.
- If you cannot find a command on the ribbon, right-click a row number for the context menu. On Windows, Ctrl+Shift+9 is a shortcut for unhiding rows when the relevant rows are selected. Keyboard shortcuts can vary by keyboard layout and Excel version; the ribbon or context menu is the dependable alternative.
- In Excel for Mac, use the Home tab’s Format controls or the row-header context menu; shortcut behavior may differ from Windows. In Excel for the web, try the row-header context menu or the Home tab, and open the workbook in the desktop app if a protection or formatting control is unavailable.
- For a workbook you did not create, ask the owner before clearing filters, changing groupings, or unprotecting a sheet. Those settings may be intentional and may support other users’ workflow.
Troubleshooting
Unhide is unavailable or has no effect: Confirm that the selected range includes the hidden rows, then check whether the sheet is protected. If protection is off, set the selected rows to a positive height. If Excel still will not let you edit the sheet, check whether the workbook is shared or opened with restricted permissions, and ask the owner for access.
The row numbers are consecutive, but expected records are missing: Look for filter arrows and clear the relevant filter criteria. Also check whether the records are on another worksheet, whether a table filter is active, or whether the cells are blank because a formula returns an empty result. A row can be visible while its contents are not obvious.
A plus sign or outline level appears, but the rows stay collapsed: Click the plus sign for the section, or select a cell in the collapsed group and use Data > Outline > Show Detail if available. If you do not want to alter the outline, ask the workbook owner before changing its grouping.
The row height changes, but the text still does not show: Check the cell contents in the formula bar and inspect font color, number formatting, and conditional formatting. The cell may contain no value, or its text may match the fill color. Also check for wrapped text or merged cells; these can affect how content displays, but they are not themselves a way to unhide rows.
You are using Excel for the web and cannot find the setting: Try selecting the row headers around the gap and opening the right-click menu. If the sheet is protected or the workbook’s layout controls are limited in the browser, open it in the Excel desktop app, provided you have access. The underlying cause still matters: filters, outline groups, and zero-height rows require different fixes.
Frequently Asked Questions
Why does Unhide Rows do nothing in Excel?
Usually, the selection does not include the hidden rows, or the rows are being suppressed by a filter or collapsed group instead. Sheet protection and zero-height rows are other common causes. Select the gap, check filters and outline controls, then set a positive row height if needed.
How do I unhide the first row in Excel?
Enter 1:1 in the Name Box and press Enter, then choose Home > Format > Hide & Unhide > Unhide Rows. If row 1 remains out of sight, select the whole worksheet and set the height of row 1 to a positive value. Check protection if Excel will not apply the change.
Can I unhide all rows at once?
Yes. Select the whole worksheet using the Select All button, then choose Home > Format > Hide & Unhide > Unhide Rows. This reveals manually hidden rows, but it does not clear filters or expand grouped sections, so check those separately.
Will clearing a filter delete my data?
No. Clearing filter criteria changes which existing records are displayed; it does not delete the records. If you want to keep the filter arrows and setup, clear the criteria rather than removing the filter entirely.
Why can’t I change a row’s height?
The worksheet may be protected, or you may not have permission to edit it. Check Review for Unprotect Sheet. If Excel requires a password, contact the workbook owner. Once you have authorized access, select the row and use Home > Format > Row Height.
Related
- Proper Excel Formatting: Clear, Reliable Spreadsheet Rules
- COUNT in Excel: Count Numbers in a Range
- Count Excel Rows While Excluding Hidden Rows with SUBTOTAL
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Timesheet Template: Setup, Formulas and TipsTo make a timesheet template in Google Sheets, create columns for the date, start time, end time, unpaid…
- Excel Shortcut Keys: Essential Commands for WindowsFor Excel for Microsoft 365 on Windows, the most useful shortcut keys include Ctrl+C and Ctrl+V to copy…
- Google Sheets Data Validation Dropdown: Setup and TipsTo create a Google Sheets data validation dropdown, select the cells, choose Data > Data validation > Add…
- Can You Automate Goal Seek in Excel? Methods That WorkYes. In Excel for Microsoft 365 on Windows, you can automate Goal Seek with a VBA macro; in…
- Excel Budget Conditional Formatting: Setup and RulesYes. To show which items are under budget in Excel, select the actual-spending cells and create a conditional-formatting…
- How to Set an Out of Office Reply in Microsoft OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.