Q:

Unhide row doesn't work

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 ↓, till all 15
rows selected, set height and unhide
row, still doesn't work!

How can I get them back?

A:

Select the Sort & filter icon from the home menu bar, uncheck the Filter button.
To me, it looks like bug in Excel filters.

A:

I had the issue you were describing and found that the rows were unhidden, but the row height was zero. So, unhide the rows as you describe and then hover over the row symbols on the side (in between the two rows where your rows are hidden) and then click and drag to expand the row height manually.
There's probably a visual basic script to do this that you could code up as well.

