Share this page:

MS Excel 2007: Unhide row 1

This Excel tutorial explains how to unhide row 1 in Excel 2007 (with screenshots and step-by-step instructions).

Question: How do I unhide row #1 in a sheet in Microsoft Excel 2007?

Answer: Select the Home tab from the toolbar at the top of the screen. In the Editing group, click on the Find button and select "Go To" from the popup menu.

Microsoft Excel

When the GoTo window appears, enter A1 in the Reference field and click on the OK button.

Microsoft Excel

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Rows.

Microsoft Excel

Row 1 should now be visible.

Microsoft Excel