row won't unhide

[Guest]

I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!

 

[PCLIVE]

Maybe the row is not actually hidden. Try selecting all cells by clicking
the blank block next to your column header A and above Row 1. This should
select all cells in the sheet. Then go to Format-Row-AutoFit.

HTH,
Paul

 

[Guest]

Perhaps it only appears to be hidden and in fact is just set to a minimal Row
Height.

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

Maybe
Data|filter|show all
would help.

I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!

 

[Guest]

Yes it did. I found that right after I ask the question. I don't know how a
filter got applied, but I guess it did. Thanks