Cells ignore Wrap Text formatting!
 

Hello,
I like using 'Wrap Text' cell formatting in my spreadsheets. I like how it
nicely automatically adjusts the cells for anything with alot of textual
information.

Sometimes I accidentally resize the row height. Whenever I do so, that cell
suddenly doesn't auto size anymore!

How can I fix this?

I've tried going back into cell format and turning off/on 'wrap Text',
re-typing in the text, but nothing works.

Cells ignore Wrap Text formatting!
 

Try selecting Format/Row/AutoFit from the menu bar.

--
Rick (MVP - Excel)


"phillr" wrote in message
...
Hello,
I like using 'Wrap Text' cell formatting in my spreadsheets. I like how it
nicely automatically adjusts the cells for anything with alot of textual
information.

Sometimes I accidentally resize the row height. Whenever I do so, that
cell
suddenly doesn't auto size anymore!

How can I fix this?

I've tried going back into cell format and turning off/on 'wrap Text',
re-typing in the text, but nothing works.

Cells ignore Wrap Text formatting!
 

that did it! thanks!

"Rick Rothstein" wrote:

Try selecting Format/Row/AutoFit from the menu bar.

--
Rick (MVP - Excel)


"phillr" wrote in message
...
Hello,
I like using 'Wrap Text' cell formatting in my spreadsheets. I like how it
nicely automatically adjusts the cells for anything with alot of textual
information.

Sometimes I accidentally resize the row height. Whenever I do so, that
cell
suddenly doesn't auto size anymore!

How can I fix this?

I've tried going back into cell format and turning off/on 'wrap Text',
re-typing in the text, but nothing works.