Gary E answered 5 years ago
First try selecting the “cell” above the row numbers and left of the column numbers (to select the entire worksheet) and then selecting Format > Row > Unhide. If that doesn’t work or you just don’t want to unhide all rows, then follow the directions below.
In your workbook enter Alt+F11 (or right click on a worksheet name tab and select View Code.)
In the big window under the words Option Explicit, paste the following code.
Range("A1:A4").EntireRow.Hidden = False
Place the cursor on the first line of this code and press F8 three times (or F5 once.)
That will unhide rows 1 – 4 without affecting any others.
Source : http://answers.yahoo.com/activity?show=YXXVW3O7VMNZAHDRLGF6G2TKHM&t=g