Merged cells stop wrapping

[TJ Daniel]

I've created a form in excel with merged cells. I've got it set-up to wrap
text & shrink to fit. It works well - for a few lines - then for some reason
it just stops wrapping the text.

I've tried with row & column cells merged - and with only row cells merged.

It almost appears that there is a maximum capacity for wrapping?

 

[Dave Peterson]

Try adding alt-enters every 80-100 characters.

You may have to manually adjust the rowheight, too.

 

[Gord Dibben]

Row Autofit will not work with merged cells unless you add event code to
your worksheet.

If you "MUST" use merged cells and you want to go that route...............

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which is all one line.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

On Tue, 16 Jun 2009 09:04:03 -0700, TJ Daniel <TJ

 

[TJ Daniel]

I'm trying to create a form for others to use - so the alt-enter would be
more cumbersome if I can avoid it.

Even if I manuall adjust the row height - it still only wraps for the first
part of the text.

Any other suggestions?

 

[Dave Peterson]

Use a textbox?

I'm trying to create a form for others to use - so the alt-enter would be
more cumbersome if I can avoid it.

Even if I manuall adjust the row height - it still only wraps for the first
part of the text.

Any other suggestions?