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.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the Format button in the Cells section of the ribbon at the top of the window.
Step 5: Click the Hide & Unhide option, then click Unhide 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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.