Excel won't allow access to some rows!--- Very strange!!

I

Investwise

I have a strange problem with one of my spreadshteets. I am not able
to access or see any rows 1 to 31. It is as if the "hide" function is
in effect. I have tried the "unhide" function, but no use. It is as
if I am locked out of these rows! I don't have any "freeze" function
active with respect to the unaccesible rows.

Anyone here knows what is going on? thanks
 
M

Martin Fishlock

When you try and unhide select the whole sheet by clicking the border above
and to the left of cell A1 and then try unhide rows and then also try row
heightr standard.
 
O

OM

Martins solution works, but it "unhides" all the rows (or columns). If you
only want to unhide (say) row 6, press F5 ("go to"), enter A6, then Unhide.
This will just unhide the one row.

Rob
 
Top