Hidden Rows

[michael.a7]

I came accros a spreasheet were the first 8 rows are hidden.

I can select and edit the cells by entering the cell reference into th
Name Box. But I cannot make them visible - the rows have a height o
15. And selecting all the cells then selecting unhide does not work.

Protection has not been applied.

Does anyone have any ideas on how this was done? and how can I mak
them visible?

Thanks

 

[Peo Sjoblom]

Press Alt + F11, press Ctrl + G, in the immediate window put

Rows.Hidden = False

press enter

press Alt + Q to close the VBE, still hidden?


--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Saruman]

Check the Window , Unfreeze Panes menu option.

I have seen this hide rows before

 

[michael.a7]

Thanks Saruman, that worked :

 

[Saruman]

Thanks for the feedback

KISS - Keep It Simple Stupid