Excel: Unhide row 1 in Excel 2007
Also learn how to unhide row #1 in Excel 2003/XP/2000/97.
Question: How do I unhide row #1 in a sheet in 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.

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

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

Row 1 should now be visible.

To learn how to hide a row, click here.
