Wrapping text

  • Thread starter Thread starter RoseAnne
  • Start date Start date
R

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!
 
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
 
Back
Top