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?

Try adding alt-enters every 80-100 characters.

You may have to manually adjust the rowheight, too.

TJ Daniel wrote:

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

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/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

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

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?

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" wrote:

Try adding alt-enters every 80-100 characters.

You may have to manually adjust the rowheight, too.

TJ Daniel wrote:

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

Use a textbox?

TJ Daniel wrote:

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" wrote:

Try adding alt-enters every 80-100 characters.

You may have to manually adjust the rowheight, too.

TJ Daniel wrote:

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


--

Dave Peterson