Excel 2007: Unhide row doesn't work

Question

One worksheet doesn't show the first 15 rows. I tried the followings, neither worked, even in full-screen mode

• step 1: F5 (Ctrl+G) to define & select 1:15, set row height to 20 and "unhide row", they are still hiding;

• Step 2: Put cursor in A16, then up.. till A1 (invisible), select entire row (Ctrl +Shift + ->), hold on shift key, press down arrow, till all 15 rows selected, set height and unhide row, still doesn't work!

How can I get them back?

Answer 1

Try the following:

Type the first cell reference A1 in the Name Box and press enter. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows.

You should be able to unhide all of the rows inbetween after that.