cell does not auto-stretch when too much text in one cell

[cpliu]

I have text of multiple lines in a cell. It seems after it reaching to
an amount, it stops auto-stretching so I can see all text in the cell.
I have manually drag it down so I can see the complete content. Is
there a way to have it auto-stretched to show all text again?

Thanks for the help,

 

[Bob Umlas]

Use Format/Row/Autofit -- you'll only have to do it once. From then on it
should "auto stretch".

Bob Umlas

 

[cpliu]

Use Format/Row/Autofit -- you'll only have to do it once. From then on it
should "auto stretch".

Thanks for the answer. Autofit makes my adjustments (expand by hand)
go back to one line. It seems that auto stretch is on when I type the
text myself. I notice the problem when I copy and paste text from
other documents for spreadsheet generated from web.

any other options?

Thanks,