Office Settings & Configuration

Unhide Thousands of Top Rows in an Excel 2013 Worksheet

Ayan MasoodAyan Masood Nov 12, 2026 870 views

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.

How to Unhide Thousands of Rows at the Top of an Excel 2013 Worksheet
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the worksheet

Open the affected worksheet in Excel 2013 and locate the Name Box to the left of the formula bar.

2
Select the hidden rows by number

Click the Name Box, type 1:1128 (replace 1128 with the last hidden row number), and press Enter. Excel selects the specified row range.

3
Unhide the selected rows

On the Home tab, select Format in the Cells group, choose Hide & Unhide, and then select Unhide Rows.

4
Verify the first visible row

Scroll to the top of the worksheet and confirm that row 1 and the previously hidden rows are visible.

Select the hidden top-row range with the Name Box and unhide it
Rows restored: If the command succeeds, the worksheet will return to the selected top row range and display its row headers.
Manage hidden worksheet rows easily

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. 1. Open the Excel workbook: Launch WPS Spreadsheet and open the affected .xlsx or .xls worksheet.
  2. 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. 3. Unhide the selected rows: On the Home tab, open Format, choose Hide & Unhide, and select Unhide Rows.
  4. 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.
Select large hidden row ranges directly through the Name BoxUnhide rows and adjust row height from the Home tabOpen and edit Microsoft Excel .xlsx and .xls files with format compatibilityUse a lightweight, familiar spreadsheet interface for worksheet layout tasks
QA img-9

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.