Wrapping text

[RoseAnne]

I have a large spreadsheet that has 5 columns. One of the
columns has large amounts of text input. When using the
wrap feature, it cuts off the text?? If I make the column
larger, it makes no difference, it just cuts it off at a
different place. If I use "shrink to fit" it puts in one
line that is not readable, and no other text shows, but I
can see it in the formuala bar. Anyone have any
suggestions??

Thanks!

 

[Greta]

Did you try making the row higher?
g

 

[Gord Dibben]

Roseanne

Excel allows 32,767 characters in a cell but will show or print only 1024(see
Help>Specifications).

One workaround is to spread a few ALT + ENTER's at spots. This will increase
the amount shown. Don't know how far this will go.

Gord Dibben Excel MVP - XL97 SR2 & XL2002