Hidden Rows

M

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
 
P

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
 
S

Saruman

Check the Window , Unfreeze Panes menu option.

I have seen this hide rows before
 
Top