View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do you wrap larger quantites of text?

You can see much more than those 1000 or so characters that Alan wrote about
(and that excel's help documents) by adding alt-enters (to force a new line
within the cell) every 80 or 100 characters.

And this can help take care of the problem you're seeing, too--when the text
just seems to fade away....

Coke wrote:

I know how to re-size cells, automatically wrap text and auto-fit, but the
wrapping doesn't seem to work for all text, eg a long paragraph might wrap
fine up to the 15th line (which is say half way through a long paragraph) and
from the 15th line on won't wrap no matter how much you increase the cell
height or width? Any suggestions welcome?


--

Dave Peterson