To unhide row 1 in the worksheet in Excel 2007
Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
Click on the Home tab on the ribbon.
Click on the Format icon on the ribbon to open the drop down list.
Choose Hide & Unhide > Unhide Rows from the drop down list.
Row 1 will become visible.
To unhide row 1 in the worksheet in Excel versions 97 to 2003
Type the cell reference A1 in the Name Box and press the Enter key on the keyboard.
Click on the Format menu.
Choose Row > Unhide in the menu.
Row 1 will become visible.
To unhide multiple Rows in the worksheet - all versions of Excel
For example, you want to unhide rows 2, 4, and 6.
In the row header drag select to highlight rows 1 to 7.
Right click on the selected rows.
Choose Unhide from the menu.
The hidden rows and the row letters will be visible.