We have an Excel document which needs to support rather lengthy text entries.
We formatted the cell to wrap the text, but at a certain point, it stops
wrapping.

In the Knowledge base, I've found basic information regarding formatting
cells and it included the following statement.

" Select Wrap Text to wrap the text in the selected cell. The number of
wrapped lines depends on the width of the column and the length of the cell
contents."

So I guess my question is does anyone know how to control the number of
wrapped lines OR is there a fixed limit to the text wrapping in Excel?

Thank you

It is not a wrapping problem.

You can enter 32767 characters in a cell but, by default, only 1024 of those
will show or print.

You can expand this 1024 limit by ALT + ENTER to insert a carriage return
every couple hundred characters.

Using a smaller font in conjunction with the above will also assist with
expansion.


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 07:59:07 -0700, "Adelrose"
wrote:

We have an Excel document which needs to support rather lengthy text entries.
We formatted the cell to wrap the text, but at a certain point, it stops
wrapping.

In the Knowledge base, I've found basic information regarding formatting
cells and it included the following statement.

" Select Wrap Text to wrap the text in the selected cell. The number of
wrapped lines depends on the width of the column and the length of the cell
contents."

So I guess my question is does anyone know how to control the number of
wrapped lines OR is there a fixed limit to the text wrapping in Excel?

Thank you