View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What controls row expansion to show muli-line text in a word-wrap

Are you using "merged" cells?

These will wrap text but will not autofit.

You would have to use event code behind the worksheet to achieve
autofitting.


Gord Dibben MS Excel MVP


On Wed, 18 Mar 2009 09:34:13 -0700, Bill45
wrote:

I seem to have difficulty when entering text into a cell and the row size not
expanding to show all of the data. I'm not talking about being beyond the
character limits of a cell. I use word wrap for the cell but the row height
doesn't enlarge to show all text entered. I've even tried Format, Row,
AutoFit unsuccessfully. I have to go over to the far left and manually drag
the row down to make it larger. Surely there's a way to have this occur
automatically?
Thank you.