Why Are Row Numbers Missing in Excel 2013?

Are you working on a spreadsheet that you got from someone else, and you notice that the row numbering is not sequential?

This is occurring because the person that created the spreadsheet elected to hide some rows.

Often this is done because the cells in certain rows contain irrelevant information, information that is part of a formula and should not be edited, or because it negatively affects the display of the spreadsheet.

Fortunately, it is possible to unhide these rows so that you can view and edit the information contained within them. Our guide below will show you how.

How to Show Missing Rows in Excel 2013

The steps below are going to show you how to unhide all of the hidden rows in Excel 2013. Often times rows are hidden for a good reason, and you may find that displaying the hidden rows makes the spreadsheet difficult to read. You can read this article to learn how to hide rows in Excel 2013.

Step 1: Open the spreadsheet with the hidden rows in Excel 2013.

Step 2: Click the cell at the top-left corner of the spreadsheet, between the 1 and the A. This is going to select the entire worksheet.

select the entire worksheet

Step 3: Click the Home tab at the top of the window.

click the home tab

Step 4: Click the Format button in the Cells section of the ribbon at the top of the window.

click the format button

Step 5: Click the Hide & Unhide option, then click Unhide Rows.

unhide the rows

Now that you know more about why row numbers might be missing fro an Excel 2013 spreadsheet, you can use the options above to restore rows that might have been hidden from the sheet in the past.

Are you running into problems with multi-page Excel spreadsheets that are hard to read when they are printed? Print the header row on every page and make it easier to associate cells with their appropriate columns.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy