Unhide Thousands of Top Rows in an Excel 2013 Worksheet
Question details
Unhide a large range of hidden rows at the beginning of an Excel worksheet when the row headers for those rows are not visible.

- Product
- Microsoft Excel 2013
- Device & OS
- not provided
- Scenario
- The worksheet opens at a later row, such as row 1129, and the user needs to restore rows 1 through approximately 1,128.
- Observed behavior
- The top row numbers cannot be selected with the mouse because the rows are hidden, making the normal row-header method unavailable.
Confirm the approximate first and last hidden row numbers before changing the worksheet. If the workbook opens on a later row, click the Name Box to the left of the formula bar rather than trying to drag the missing row headers.
Select the hidden top-row range with the Name Box and unhide it
Use this method when the hidden row numbers are not visible and cannot be selected with the mouse.
The Name Box can select rows even when their row headers are hidden. Selecting the full hidden range first lets Excel apply the Unhide Rows command to it.
Open the affected worksheet in Excel 2013 and locate the Name Box to the left of the formula bar.
Click the Name Box, type 1:1128 (replace 1128 with the last hidden row number), and press Enter. Excel selects the specified row range.
On the Home tab, select Format in the Cells group, choose Hide & Unhide, and then select Unhide Rows.
Scroll to the top of the worksheet and confirm that row 1 and the previously hidden rows are visible.

Restore a normal row height and check worksheet restrictions
Use this solution if Unhide Rows does not reveal the rows, because rows may have a height of zero or the sheet may be protected.
Restore Hidden Top Rows with WPS Spreadsheet
WPS Spreadsheet provides a straightforward way to select a hidden row range by using the Name Box, then restore the rows from the Home tab. Open the Excel workbook in WPS Office and manage row visibility without needing to drag inaccessible row headers.
- 1. Open the Excel workbook: Launch WPS Spreadsheet and open the affected .xlsx or .xls worksheet.
- 2. Enter the hidden row range: Click the Name Box beside the formula bar, enter a range such as 1:1128, and press Enter.
- 3. Unhide the selected rows: On the Home tab, open Format, choose Hide & Unhide, and select Unhide Rows.
- 4. Reset row height if necessary: If rows are still not visible, select the worksheet, go to Home > Format > Row Height, and enter a standard height.

Frequently Asked Questions
How can I select hidden rows when row 1 is not visible in Excel?
Click the Name Box to the left of the formula bar, type the row range such as 1:1128, and press Enter. Then use Home > Format > Hide & Unhide > Unhide Rows.
Why are my Excel rows still missing after I choose Unhide Rows?
The rows may have a height of zero rather than only being hidden. Select the worksheet, then go to Home > Format > Row Height and enter a normal value, such as 15.
Can worksheet protection prevent me from unhiding rows?
Yes. On the Review tab, look for Unprotect Sheet. Remove protection with the required password, then use Home > Format > Hide & Unhide > Unhide Rows.
Could Freeze Panes make the first rows seem hidden?
Yes. Go to View > Freeze Panes > Unfreeze Panes, then scroll to the top of the sheet to check whether the rows are actually visible.




