Instead of merging cells, expand the column width to whatever is required,
select a cell within this column, use autofit, text wrap, justification, this
should do the trick.

If the position of the text cell makes it impracticable to expand the column
width, move the actual data entry cell off to the right of your work area,
putting a simple macro button in the original place that redirects the user
to the new space, adding a similar button adjacent to this point for the user
to return to the form.

"SteveFerd" wrote:

Thanks in advance for you help,

I am creating a template which will be used to track large accounts. Text
will be entered directly into cells, and most of the text will not require
the row to expand in size. For the cases where I need an unlimited amount of
room for text entry, I merged the cells across most of the printable field
and then checked text wrap, and align left, but I can't get it to work. In
addition I have formatted the rows to allow autofit, so then can expand
automatically. What do I need to do to fix this simple problem?

Thanks,
Steve