View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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.