How to Unhide Top Rows in Excel (Rows 1 to 4080)
Question details
The user needs to unhide a large contiguous block of rows at the very top of a worksheet, specifically from row 1 up to row 4080.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- A massive block of data at the top of an active spreadsheet has been hidden, making it difficult to manually select the hidden range to restore row visibility.
- Observed behavior
- Rows 1 through 4080 are entirely invisible on the worksheet, preventing access to the data stored within them.
Ensure your worksheet is not password-protected, as locked sheets restrict layout modifications like unhiding rows. Additionally, verify that the rows aren't simply hidden by an active data filter.
Unhide Rows Using the Select All Button
The quickest method to restore visibility to all hidden rows across the entire worksheet without needing any coding skills.
Since row 1 is hidden, you cannot simply drag your mouse to select the rows surrounding it. The 'Select All' function is the most reliable way to ensure the top rows are included in your selection before applying the unhide command.
Click the 'Select All' triangle button located in the top-left corner of the worksheet, where the column letters and row numbers intersect. Alternatively, press 'Ctrl + A' on your keyboard.
Hover your cursor over any visible row number heading on the left side of the screen and right-click.
Select 'Unhide' from the context menu. This action will immediately reveal all hidden rows, including rows 1 through 4080.

Unhide Specific Rows Using a VBA Macro
If you only want to unhide rows 1 to 4080 specifically, without affecting other intentionally hidden rows further down the sheet, a VBA macro is the most precise solution.
Easily Manage and Unhide Rows in WPS Spreadsheet
WPS Office Spreadsheet provides a seamless and intuitive interface for managing large datasets. You can effortlessly hide, unhide, and format thousands of rows at once, with full support for advanced data manipulation and VBA macros.
- 1. Open Your File: Launch WPS Spreadsheet and open the document containing the hidden rows.
- 2. Select All Cells: Click the small triangle icon in the upper-left corner of the grid to select the entire sheet.
- 3. Right-click and Unhide: Right-click on any visible row header and choose 'Unhide' to reveal your data.

Frequently Asked Questions
Why can't I unhide Row 1 even after selecting the whole sheet?
If row 1 remains hidden after using the standard unhide method, it is likely due to 'Freeze Panes' locking the view. Go to the 'View' tab, click 'Freeze Panes', and select 'Unfreeze Panes'. Afterward, try unhiding the rows again.
Is there a way to unhide rows using the Go To feature?
Yes. Press 'F5' to open the 'Go To' dialog box, type '1:4080' in the Reference field, and press Enter to select those specific hidden rows. Next, go to the 'Home' tab, click 'Format', select 'Hide & Unhide', and click 'Unhide Rows'.
Can active data filters prevent me from unhiding rows?
Yes. If the rows disappeared because they were filtered out based on data criteria, the standard 'Unhide' command won't work. You must clear the filter by navigating to the 'Data' tab and clicking 'Clear' in the Sort & Filter group.
Will unhiding thousands of rows mess up my worksheet formatting?
No, unhiding rows simply restores their visibility and reverts them to their previous row height. It does not alter the cell styles, colors, or the data contained within those rows.




