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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Investwise - 30 Dec 2006 08:21 GMT

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

Reply to this Message

Martin Fishlock - 30 Dec 2006 08:54 GMT

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.

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> 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
[quoted text clipped - 3 lines]
>
> Anyone here knows what is going on? thanks

Reply to this Message

OM - 02 Jan 2007 09:34 GMT

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

>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
[quoted text clipped - 3 lines]
>
> Anyone here knows what is going on? thanks

Reply to this Message

Rate this thread: