Exceed text limit in a merged cell

  • Thread starter Thread starter mrlanier
  • Start date Start date
M

mrlanier

If I merge cells from A1 through I20, I can wrap text only through row
11 and not the full 20 rows. Excel appears to have a limit. Is there
a function or macro that will increase the amount of text that can be
entered? Thanks.

Michael
 
Instead of merging the cells, concatenate the data into a text box (which
has no character limit).
 
2 questions: will this print out as part of a document, and how is this
done? Thanks.

Michael
 
Yes, it prints. You can even link it to a cell, format its appearance for
printing, etc.

You need to use a macro to accomplish this, which I cannot help you with as
I am a novice at VBA. Someone else might pipe in or you can post this
question to the programming newsgroup.
 
Back
Top