Office Settings & Configuration

How to Unhide Rows 1-7 in Microsoft Excel

Tauseeq Magsi Sep 29, 2026 869 views

Question details

The user needs to reveal the uppermost rows (specifically rows 1 through 7) that are currently hidden in a Microsoft Excel worksheet.

How to Unhide Rows 1–7 in Microsoft Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating or editing a spreadsheet where the topmost rows containing headers or critical data are missing from the view.
Observed behavior: Rows 1 to 7 are invisible on the worksheet grid, likely concealed due to row formatting, applied data filters, grouped outlines, or worksheet protection.

Before you start

Before attempting to unhide the rows, ensure your worksheet is not protected by a password, as protected sheets restrict formatting changes like adjusting row visibility.

Solution 1Recommended

Unhide Top Rows Using the Select All Method

This is the most reliable method to unhide top rows because selecting the entire worksheet guarantees the hidden rows are included in your selection.

When row 1 is hidden, you cannot simply drag to select the rows above and below it. Using the 'Select All' shortcut ensures that the hidden top rows are encompassed in the unhide command.

Select the entire worksheet

Click the small triangle in the top-left corner of the worksheet (where the row numbers and column letters intersect), or press Ctrl+A on your keyboard to select all cells.

Navigate to the Format menu

Go to the Home tab on the Excel ribbon. In the Cells group, click on the Format button.

Unhide the rows

Hover your cursor over Hide & Unhide in the drop-down menu, then select Unhide Rows. Rows 1 through 7 will immediately become visible.

Unhide Top Rows Using the Select All Method

Selection Tip: Pressing Ctrl+A twice may be necessary if your cursor is currently inside a formatted data table.

Solution 2

Reveal Hidden Rows via the Name Box

Use this method if you want to specifically target the hidden rows without affecting the selection of the rest of your worksheet.

Solution 3

Clear Data Filters or Outlines Concealing Rows

If standard unhiding methods fail, the rows might be temporarily concealed by an active data filter or a grouping outline.

WPS Spreadsheet

Easily Manage Hidden Rows with WPS Spreadsheet

You can seamlessly open your Microsoft Excel workbooks in WPS Office to manage hidden rows, configure data filters, and adjust worksheet layouts using a familiar and intuitive interface.

1. Open your file: Launch WPS Spreadsheet and open your existing .xlsx workbook.
2. Select all cells: Click the Select All triangle in the top-left corner of the grid, or press Ctrl+A.
3. Unhide the rows: Right-click on any visible row header (like row 8) and choose Unhide from the context menu to reveal rows 1-7.

Completely free to download and use for daily spreadsheet tasksFully compatible with Microsoft Excel (.xlsx and .xls) file formatsIntuitive right-click menus for instantly hiding and unhiding rows

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I unhide rows 1-7 even after selecting the entire sheet?

If rows refuse to unhide, the worksheet is likely protected, or the window is frozen. Go to the Review tab and click Unprotect Sheet (you may need a password). Also, check the View tab and select Unfreeze Panes, as frozen panes can sometimes trap top rows out of view.

Can I unhide just row 1 without selecting the whole worksheet?

Yes. You can type A1 into the Name Box (left of the formula bar) and press Enter. Then, go to Home > Format > Hide & Unhide > Unhide Rows. This will reveal just the first row without requiring you to select the entire document.

How do I unhide rows using a keyboard shortcut?

First, select the entire worksheet by pressing Ctrl+A. Then, press the keyboard shortcut Ctrl+Shift+( (the opening parenthesis key) to instantly unhide all hidden rows within your selection.

Office App Problems