Why Are Row Numbers Missing in Excel 2013?

Last updated on May 5th, 2023 at 10:52 am

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

 

 

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

Newest Guides