What controls row expansion to show muli-line text in a word-wrap

B

Bill45

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set row height, but allow wrap text 0
Wrap Text doesn't work in Merged Cell 1
word wrap without row expansion? 5
Fixing text wrap in merged cells 1
Excel 2007: Wrap Text 1
Format cell to both Wrap text and shrink to fit 1
Getting word wrap to work in a merged cell 1
How do I autofit row height to adjust to new text on Excel form? 1

Top