Lines are auto hiding in excel sheet 2003?

[shipchik]

How do we stop lines from hiding? I have selected the sheet and set the page
to expand and when I open the sheet up again many lines are hiding. Is there
a simple fix for this. This is a large sheet approx. 2.3MB that is on a
shared network.
Thank you for your help.
Barb

 

[Gord Dibben]

What are "lines"?

Do you mean rows?

Or lines of text within cells?

How did you set the sheet to expand?

Do you mean you set wraptext on cells and set rows to autofit?


Gord Dibben MS Excel MVP

 

[shipchik]

Hi Gord,

Do you mean rows? Yes
Do you mean you set wraptext on cells and set rows to autofit? Yes

Even after the autofit we have saved the worksheet and we are still finding
rows are hiding after we re open the worksheet.

Barb