row won't unhide

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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
 
Perhaps it only appears to be hidden and in fact is just set to a minimal Row
Height.

Vaya con Dios,
Chuck, CABGx3
 
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!!!
Click to expand...
 
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
 
Back
Top