Word Wrap problem in Excel

M

Mike Harlan

I created a form using Excel 2000. One of the "fields" in
the form is actually a freeform text area containing 13
row, 10 columns wide (which I merged together to form a
single cell). I set my giant cell to word wrap, and it
seems to word wrap correctly, however, after 8 or 9 lines
of text is entered, the word wrap stops, and the remaining
text is not visible in the cell (although there appears to
be plenty of room). Any ideas?
 
C

Charlieo

A cell can only hold a certain number of characters, It is
somewhere in the area of 240.
 
H

Harlan Grove

I created a form using Excel 2000. One of the "fields" in
the form is actually a freeform text area containing 13
row, 10 columns wide (which I merged together to form a
single cell). I set my giant cell to word wrap, and it
seems to word wrap correctly, however, after 8 or 9 lines
of text is entered, the word wrap stops, and the remaining
text is not visible in the cell (although there appears to
be plenty of room). Any ideas?
Click to expand...

If you add newline characters, CHAR(10), every 100 characters or so, Excel will
display multiples of the putative limit of 1024 characters per cell.
 
D

Dave Peterson

If you add a few alt-enters to force new lines in the cell, you can exceed
excel's documented limit of 1000 characters viewable (32k in the formulabar).

But since you have merged cells, you'll have to set the rowheight manually.
 
Top