Dealing with Excel's Word-Wrap Limit
 

I have found that Excel will only automatically word-wrap up to 1024
characters in a cell; any additional text after that will just continue on
the last line and will run out of sight off the edge of the cell except when
being edited. I have a sheet that requires lengthy text comments by the
users, and the 1024 character limit is not going to enough.

It is possible to force additional line breaks in the text using Alt^Enter,
but this is not a good solution for my mostly non-technical users, plus the
word wrapping breaks at different points in Excel's edit mode than it does
otherwise making it difficult to determine where a line needs to be inserted.

Is there a way to increase the chararacter limit that Excel will word-wrap?
Or does anyone have any clever ideas on how else I can have users enter
lengthy commentary on an Excel sheet... perhaps an embedded control or
something?

Thanks for any suggestions,

TK

Dealing with Excel's Word-Wrap Limit
 

Maybe use a textbox from the control toolbox toolbar?

T Kirtley wrote:

I have found that Excel will only automatically word-wrap up to 1024
characters in a cell; any additional text after that will just continue on
the last line and will run out of sight off the edge of the cell except when
being edited. I have a sheet that requires lengthy text comments by the
users, and the 1024 character limit is not going to enough.

It is possible to force additional line breaks in the text using Alt^Enter,
but this is not a good solution for my mostly non-technical users, plus the
word wrapping breaks at different points in Excel's edit mode than it does
otherwise making it difficult to determine where a line needs to be inserted.

Is there a way to increase the chararacter limit that Excel will word-wrap?
Or does anyone have any clever ideas on how else I can have users enter
lengthy commentary on an Excel sheet... perhaps an embedded control or
something?

Thanks for any suggestions,

TK

--

Dave Peterson