How to Unhide Row 1 or Column A in Microsoft Excel

Hiding rows and columns is a standard technique in Microsoft Excel to streamline reports, hide confidential formulas, and declutter financial summaries. When you hide intermediate rows (such as rows 4, 5, and 6), unhiding them is straightforward: you simply select rows 3 and 7, right-click the row numbers, and click “Unhide”. However, when Row 1 or Column A is hidden, this familiar method fails because there is no preceding row or column header to drag across.

Attempting to click and drag the boundary between the row headers and the top corner often results in resizing Row 2 instead of exposing Row 1. Fortunately, Microsoft Excel provides several reliable methods to bring Row 1 or Column A back into view. In this guide, you will learn the most effective techniques to unhide Row 1 or Column A across Excel for Windows, Mac, and the web.

Method 1: Use the Name Box to Select the Hidden Cell (Fastest)

The Name Box sits immediately to the left of the Formula Bar and allows direct navigation to any cell address, even if that cell is completely hidden:

1. Click inside the Name Box situated in the upper-left corner above column headers.
2. Type A1 into the box and press Enter. Excel immediately navigates to cell A1, selecting it behind the hidden boundary.
3. In the Home tab on the Excel ribbon, look to the Cells group on the right.
4. Click Format > Hide & Unhide.
5. Click Unhide Rows (or Unhide Columns if Column A is missing).

Row 1 or Column A will instantly reappear in full view.

Method 2: Use the Select All Button and Right-Click

If you prefer using your mouse, selecting the entire worksheet guarantees that the hidden first row is included in your selection:

1. Click the small triangle icon in the top-left corner of the grid (where row numbers and column letters intersect). Alternatively, press Ctrl + A on Windows or Cmd + A on Mac.
2. Hover your mouse cursor over any row number (such as Row 2 or Row 3).
3. Right-click the row header number and choose Unhide from the context menu.
4. To unhide Column A, right-click any column letter (such as Column B or C) and select Unhide.

Method 3: Double-Click the Split Line Boundary

Excel provides a subtle visual cue when Row 1 or Column A is hidden:

• Look at the top border of Row 2’s header. You will notice a double horizontal divider line instead of a standard single line.
• Carefully position your mouse pointer over this double line until your cursor changes from an arrow into a two-way split arrow with two parallel lines.
• Double-click the divider. Excel will immediately expand Row 1 to its default height.

Troubleshooting: Why Row 1 Still Won’t Unhide

If you have followed the steps above and Row 1 remains invisible, check for these common configuration roadblocks:

• Row Height Set to Zero: Select cell A1 via the Name Box, then navigate to Home > Format > Row Height and enter 15 or click AutoFit Row Height.
• Freeze Panes Glitch: If freeze panes was configured below Row 1 while Row 1 was scrolled off screen, it may appear hidden. Go to the View tab and click Freeze Panes > Unfreeze Panes.
• Protected Sheet: If the worksheet is protected, unhiding options will be greyed out. Navigate to the Review tab and click Unprotect Sheet.