If Excel is not showing all rows, first check whether the missing rows are hidden, filtered out, or collapsed in a group. On Windows, select the whole worksheet using the triangle at the top-left corner of the grid, then choose Home > Format > Hide & Unhide > Unhide Rows; if the rows return, they were hidden manually or set to zero height.
Start by identifying what is missing
Look at the row numbers along the left edge of the worksheet. If they jump from 4 to 8, for example, rows 5 through 7 are not currently visible. That gap confirms the issue is with row visibility, but it does not tell you why those rows disappeared. Manual hiding, an active filter, a collapsed outline group, and zero row height can all produce a similar result.
Notice whether the column filter buttons show funnel symbols, whether a plus sign appears beside the row numbers, and whether the missing area has unusually small row spacing. These clues often reveal the cause before you change anything. Also check the worksheet tabs: the data may be on a different sheet, or the rows you expect may simply be blank.
A useful distinction is that filtering changes which records meet the current criteria, while hiding changes whether selected rows are displayed. A filter can hide dozens of records without deleting them. In either case, the underlying data normally remains in the workbook.
Unhide rows that were hidden manually
For rows hidden by a user, select the row headers immediately above and below the gap, right-click the selection, and choose Unhide. For example, if row numbers go from 10 to 15, select row headers 10 and 15, right-click, and choose Unhide. Selecting the neighboring headers is important: selecting only a visible row inside the gap is impossible because the hidden rows cannot be clicked on the grid.
You can also use the ribbon. Select the relevant surrounding row headers, then choose Home > Format > Hide & Unhide > Unhide Rows. If you are unsure which rows are hidden, click the Select All triangle where the row and column headings meet, then use the same ribbon command. This can restore manually hidden rows throughout the worksheet, so use a narrower selection if you want to preserve intentional hiding elsewhere.
On Windows, Ctrl+Shift+9 is the keyboard shortcut for unhiding rows after selecting the rows around the gap. On a Mac, Command+Shift+9 is the corresponding shortcut in Excel, though keyboard settings can affect shortcut behavior. The ribbon command is a dependable alternative on either platform.
Rows hidden at the very top of a sheet can be tricky because there is no visible row header above them. Click the Name Box to the left of the formula bar, type A1, and press Enter to select the first cell. Then use Home > Format > Hide & Unhide > Unhide Rows. If that does not help, select the whole sheet and repeat the command.
Clear filters that are hiding records
If a filter is active, Excel displays only rows that match its criteria. The row numbers may skip, just as they do when rows are hidden manually, but the filter arrows in the heading row provide a clue. A funnel icon on a column’s filter button usually indicates that a condition is applied to that column.
To restore filtered-out records without removing the filter controls, choose Data > Sort & Filter > Clear. You can also open the filter menu for the relevant column and select the command to clear that column’s filter. The exact wording in a filter menu depends on the type of filter; for example, a text or date filter may show a clear-filter command specific to that field.
To turn filtering off entirely, click a cell in the filtered data and choose Data > Sort & Filter > Filter, or use Ctrl+Shift+L on Windows. On a Mac, use the Filter command on the Data tab if the shortcut differs in your setup. Turning filtering off removes the drop-down controls; clearing criteria is usually preferable when you want to keep filtering available.
For example, a sales table may show only orders marked Complete because a Status filter is active. Clearing that filter restores the other statuses. It does not change the status values or delete records. If clearing filters does not restore the expected rows, check whether the data has more than one filtered range or table, and inspect each relevant filter button.
Filtering can also make a sheet appear incomplete when the criteria are not obvious. Open the filter menu and inspect checked values, search terms, and date or number conditions. A filter for dates in one month, for instance, can hide valid records from other months even if the column looks ordinary at a glance.
Expand collapsed outline groups
Excel’s grouping feature lets you collapse sections of rows, often to summarize a detailed report. When a group is collapsed, a plus sign appears beside the affected rows, and outline level buttons such as 1, 2, or 3 may appear above the row numbers. Click the plus sign to expand that group. Clicking a higher outline level can display more detail across the worksheet.
If the outline controls are not visible, look for a small grouping bracket beside the row headings. The Data tab contains outline controls, including Show Detail and Hide Detail when the selection is within a group. These controls are distinct from ordinary hide and unhide commands: unhide may not expand a collapsed group because the group’s detail is still controlled by its outline state.
Groups are common in worksheets that show monthly totals with daily details underneath. A collapsed month might display its summary row while hiding the individual days. Expanding the group reveals those detail rows without changing the summary or removing the grouping structure.
Check whether row height is zero or too small
A row can be technically visible but have a height so small that its contents cannot be seen. This can happen if someone sets the row height to zero or drags the boundary between row headings until the row nearly disappears. The result can look like a manually hidden row, especially when several rows have been affected.
Select the row headers around the missing area, then choose Home > Format > Row Height and enter a reasonable value. For ordinary text, a height around 15 points is a common starting point, but wrapped text or larger fonts may need more space. You can also choose Home > Format > AutoFit Row Height to let Excel adjust selected rows to their contents.
If you cannot select the affected row directly, select the neighboring row headers or the entire worksheet first. Then set the height or use AutoFit Row Height. Keep in mind that AutoFit may not produce the layout you want when cells are merged, because merged cells can limit how Excel calculates the required height.
Consider other causes before changing the workbook
Worksheet protection can prevent you from changing row visibility or height. If the unhide command is unavailable or does not work, check Review > Protect Sheet. If the sheet is protected, you may need permission or the password from its owner to unprotect it; do not assume the missing rows can be restored by changing another setting.
Freeze Panes can make a worksheet feel as if rows are missing because a set of headings stays fixed while the rest of the sheet scrolls. It does not hide rows. Choose View > Freeze Panes > Unfreeze Panes if the frozen area is obstructing navigation, then scroll through the sheet again. The Mac ribbon has the same general View controls, though placement can vary by version.
Sometimes the rows are present but their contents look missing. A formula may return an empty string, cells may contain only spaces, or the font color may match the fill color. Click a cell where you expect data and inspect the formula bar. If the cell contains a formula or value, the row itself is not missing; the issue is with the displayed content or formatting.
Also distinguish worksheet display from printing. A print area, page breaks, or print scaling can leave rows out of a printed page without hiding them in the worksheet grid. If rows appear on screen but not on paper or in print preview, review Page Layout > Print Area and the print settings rather than using Unhide Rows.
A careful recovery sequence
When the cause is unclear, work through checks in an order that avoids changing more than necessary:
- Inspect the row numbers, filter buttons, and outline symbols to identify likely causes.
- Clear relevant filters and expand any collapsed groups.
- Select the row headers around each remaining gap and use Unhide.
- If rows are still difficult to see, select the area and set a suitable row height or use AutoFit Row Height.
- If commands are unavailable, check sheet protection and ask the workbook owner for access if needed.
- Save the workbook after confirming that the restored rows and filters behave as expected.
Avoid selecting the entire sheet and changing all row heights as a first step if the worksheet has carefully formatted sections. A targeted fix preserves intentional layout choices. If the file is shared, it is also worth asking whether hidden rows or filters are deliberate; reports sometimes hide archived, confidential, or intermediate records on purpose.
Frequently Asked Questions
Why do my Excel row numbers skip?
Skipped row numbers usually mean that rows are hidden, filtered out, or inside a collapsed outline group. Check for funnel icons and plus signs, then clear filters or expand groups before using Unhide Rows.
How do I unhide row 1 in Excel?
Type A1 in the Name Box to select the top of the sheet, then choose Home > Format > Hide & Unhide > Unhide Rows. If necessary, select the entire worksheet and repeat the command.
Why does Unhide Rows not work?
The rows may be filtered, grouped, or set to a very small height rather than manually hidden. Sheet protection can also block changes. Check each cause separately and use the matching command.
Does clearing a filter delete rows?
No. Clearing a filter shows records that were excluded by its criteria; it does not delete them. Turning the filter controls off also does not delete the underlying records.
Why can I see rows in Excel but not when I print?
Print settings such as a print area or page scaling can exclude rows from the printed output while leaving them visible in the worksheet. Check the print preview and page layout settings rather than changing row visibility.
Related
- Excel Attendance File to Print: Set Up and Print It
- Excel Timesheet Format: Build a Reliable Weekly Sheet
- Excel Timesheet for Multiple Employees: Setup and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Hide the Rest of the Columns in ExcelTo hide every column to the right of your data in Excel for Microsoft 365 on Windows, select…
- Personal Distribution Lists in Outlook: Create and ManageTo create a personal distribution list in Outlook, open People or Contacts, choose the option to make a…
- Mailing Address Labels in Word: How to Create ThemTo create mailing address labels in Word, use Mail Merge: prepare an address list, choose the matching label…
- Excel Data Model: What It Is and How to Use ItExcel’s Data Model is a built-in way to connect tables and analyze them together in PivotTables, without first…
- How to Remove a Blocked Sender in Outlook SettingsTo remove a blocked sender in Outlook, open your email account’s junk or blocked-senders settings, find the address…
- Excel Table Saw: Models, Safety, and Buying AdviceAn Excel table saw is a woodworking saw sold under the Excel name; it is not a Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.