how many lines can be in wrap text within a cell?
 

I can only make the first 10 lines wrap within one cell and the rest will not
wrap appropriately. Any solution to wrap more than 10 lines of text per cell?

Excel limits the number of characters that can be input in to a cell, if you
are over 1024 characters in the cell, it will not allow you to enter more.
You may want to consider creating a table in Word, or migrate your worksheet
to Access and create a memo field.

"pearsms" wrote:

I can only make the first 10 lines wrap within one cell and the rest will not
wrap appropriately. Any solution to wrap more than 10 lines of text per cell?

Pablo

Not entirely correct.

Excel will allow 32,767 characters to be entered in a cell.

The kicker is that only 1024 of these will be visible.

You can squeeze more in if you use the ALT + ENTER as Frank suggests.

Using a smaller font will also get more visible.

Gord Dibben Excel MVP

On Mon, 27 Dec 2004 09:13:56 -0800, "Pablo Picasso"
wrote:

Excel limits the number of characters that can be input in to a cell, if you
are over 1024 characters in the cell, it will not allow you to enter more.
You may want to consider creating a table in Word, or migrate your worksheet
to Access and create a memo field.

"pearsms" wrote:

I can only make the first 10 lines wrap within one cell and the rest will not
wrap appropriately. Any solution to wrap more than 10 lines of text per cell?