If Excel’s row numbers have disappeared, first turn row headings back on: in Excel for Microsoft 365 on Windows, select View and check Headings in the Show group. If the numbers are visible but skip rows, those worksheet rows are probably hidden, filtered out, or collapsed in a group; the remedy depends on which kind of hiding is in effect.
What the row numbers tell you
The numbers along the left edge of a worksheet are row headings. They identify worksheet rows, just as the letters across the top identify columns. They are part of Excel’s interface, not values stored in cells, so deleting a cell’s contents cannot remove them. The first row is still row 1 even if its heading is not displayed.
That distinction helps diagnose two problems that can look similar:
- No row numbers appear at all: the worksheet’s row and column headings may be turned off, or the worksheet window may be unusually narrow or positioned so the headings are out of view.
- Numbers appear, but some are skipped: rows between the visible numbers are hidden, filtered out, or collapsed. For example, seeing 7 followed by 10 usually means rows 8 and 9 are not currently displayed.
These row headings are also different from numbering records inside your data. Excel does not automatically put a sequence such as 1, 2, 3 into the first column of every list. If you mean that a numbered data column is missing, that is a separate issue from missing worksheet row headings.
Turn the worksheet headings back on
On Windows, activate the affected worksheet, open the View tab, and select Headings in the Show group. If the checkbox is already selected, click it off and on again to refresh the display. This setting controls the row numbers and column letters together; Excel does not offer a separate switch for showing only one of them.
Headings are a display choice for the worksheet, so check each sheet that has the problem. A workbook can have headings visible on one tab and hidden on another. The switch does not delete data, change formulas, or alter the actual row positions; it only changes whether the labels are shown around the grid.
In Excel for Mac, select the worksheet and use the View tab’s Headings option; the exact placement can vary with the ribbon layout. In Excel for the web, look on the View tab for the headings display option. If you cannot find the control, expand the ribbon or search Excel’s commands for “Headings.” The Windows path above applies to the desktop version specified here.
Unhide rows when the numbers jump
If the headings are present but skip numbers, restore the missing rows. When the neighboring row headings are visible, select the rows immediately above and below the gap. For instance, if the sheet goes from row 7 to row 10, select rows 7 through 10 by dragging over their headings. Then choose Home > Format > Hide & Unhide > Unhide Rows. You can also right-click the selected row headings and choose Unhide.
If many rows are hidden, select the whole worksheet by clicking the small triangle where the row and column headings meet, at the top-left corner of the grid. Then use Home > Format > Hide & Unhide > Unhide Rows. This is useful when you do not know where the hidden rows are. If the headings themselves are switched off, turn them on first so you can select the worksheet using that corner control.
On Windows, Ctrl+Shift+9 is the shortcut for unhiding selected rows. It is most useful after selecting the rows around a gap. Mac keyboard shortcuts can depend on the keyboard and macOS settings, so the ribbon command or the row-heading right-click menu is a dependable alternative there. Unhiding rows does not remove their contents; it makes those existing rows visible again.
Check filters, outline groups, and row height
A filter can hide records without hiding the rows manually. Filtered-out rows commonly make the visible row numbers jump, while the filter arrows remain in the header row. Open the relevant column’s filter menu and clear its criteria, or use Data > Sort & Filter > Clear to clear filters. Check more than one column: a record may be excluded by a filter in a column that is not immediately obvious.
Grouped rows behave differently. If someone used Excel’s outline controls to collapse detail rows, look for plus and minus buttons beside the row headings, or outline level buttons labeled with numbers. Select the plus button to expand a collapsed section. You can also use Data tab outline controls to show detail. A collapsed group is not the same as a filter: the rows are intentionally folded into a summary view rather than excluded by a column condition.
A row can also have a height of zero, which makes it effectively invisible. Select the rows on either side of the missing range and choose Home > Format > Row Height to enter a positive height, or use Home > Format > Hide & Unhide > Unhide Rows. If the missing rows are scattered, selecting the entire sheet before using Unhide Rows can reveal them together. Very small but nonzero row heights may make content hard to notice, though the row heading is usually still present.
Rule out display and workbook issues
Check that you are looking at the intended worksheet tab and that the workbook has not opened in a different window or at an unexpected scroll position. A narrow application window, a hidden ribbon, or a pane arrangement can make controls harder to locate, but zooming in or out does not normally turn off row headings. Likewise, freeze panes can keep parts of a worksheet in place while scrolling, but they are not the usual cause of row numbers disappearing.
If the heading toggle or row visibility commands are unavailable, the sheet may be protected. Check Review > Unprotect Sheet; if the sheet requires a password, you need permission and the correct password from the workbook owner. Do not assume that unprotecting is necessary just because headings are absent: the View setting often works independently. Protection is more relevant when Excel prevents you from changing row visibility.
If only one workbook has the issue, compare its affected sheet with another sheet in the same file, then with a new blank workbook. This can separate a worksheet-specific display setting from an Excel-wide display problem. If headings are missing in every workbook and the View option is selected, close and reopen Excel, check for updates, and consider whether an add-in or unusual window layout is affecting the interface before changing workbook data.
A quick order for troubleshooting
Use this sequence to avoid changing unrelated settings:
- Decide whether all row numbers are absent or only some numbers are skipped.
- If all are absent, turn on View > Headings for the active sheet.
- If numbers skip, inspect filter menus and outline controls for a filtered or collapsed view.
- Select the rows around a gap and use Home > Format > Hide & Unhide > Unhide Rows.
- If the gap remains, select the full worksheet and unhide rows, then check for zero-height rows or sheet protection.
- Repeat the heading check on other tabs; the setting may differ from sheet to sheet.
For example, if a sales worksheet shows row numbers 1 through 12 and then 18, first look for active filter arrows or a collapsed outline. If there is no filter or group, select rows 12 through 18 and unhide them. If the row labels are entirely absent instead, changing row height is unlikely to help; restore the headings through the View tab.
Common misconceptions and prevention
Missing row labels do not mean Excel has removed rows or shifted all the data. A worksheet still has its row structure when headings are hidden, and a hidden row retains its cells. Before deleting, sorting, or rebuilding a range, identify whether the problem is simply a display setting. This matters when formulas refer to particular rows or when a filtered list is being reviewed: hiding a row is not the same as deleting it.
When sharing a workbook, check whether filters or outline groups are intentionally active and tell recipients how to expand them. If readers need to see worksheet coordinates, leave headings on. If a sheet is meant to be a clean report, hiding headings can be deliberate, but it can confuse someone trying to locate a cell such as B14. Save a copy before making broad layout changes to a workbook you did not create, particularly if its structure or protection rules are unfamiliar.
Frequently Asked Questions
Why are all the row numbers missing in Excel?
Most often, the worksheet’s headings display option is off. Select the affected sheet, then turn on View > Headings in Excel for Microsoft 365 on Windows. This displays both row numbers and column letters.
Why does Excel jump from row 5 to row 9?
Rows 6 through 8 are likely hidden, filtered out, or inside a collapsed outline group. Check filter criteria and outline controls first; if neither explains the gap, select the surrounding row headings and choose Unhide Rows.
Can I restore missing row numbers without losing data?
Yes. Turning on headings only changes the worksheet display. Unhiding rows reveals existing cells; it does not erase their contents. Clearing a filter changes which records are shown, not the underlying values.
Why can’t I unhide rows in Excel?
Make sure you selected the rows on both sides of the hidden range, or select the whole worksheet and try again. Also check for a collapsed outline group or sheet protection. A filter may be hiding records, in which case clear its criteria rather than using Unhide Rows.
Are Excel row numbers the same as numbering in my list?
No. Row headings identify positions on the worksheet, while a numbered column is ordinary cell data. Turning on headings will not create a sequence in your list; that numbering has to be entered or generated separately.
Related
- Power Query Reference: What It Does and When to Use It
- Excel Data Validation: Can You Select Multiple Items?
- Protect Sheet in Excel: Allow Editing Specific Cells
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- VLOOKUP Excel Troubleshooting: Fix Common Formula ErrorsTo troubleshoot VLOOKUP in Excel, check that the lookup value is in the first column of the selected…
- IFERROR with XLOOKUP in Excel: Handle Missing ResultsYes—use IFERROR around XLOOKUP when you want to replace an error with a message or another value. With…
- Excel Too Many Arguments Error: Causes, Fixes, and ExamplesExcel’s “You’ve entered too many arguments for this function” message means a formula supplies more inputs than that…
- Excel Reference Isn’t Valid? Causes and FixesExcel’s “Reference isn’t valid” message means the action you tried to perform points to a cell range, worksheet,…
- Excel Not Increasing Numbers When Dragging? Fix ItIf Excel repeats a number instead of counting up when you drag the fill handle, select the starting…
- Excel Freeze Panes Not Freezing Selection? Fix ItExcel Freeze Panes does not lock the cell or range you select; it keeps the rows above and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.