Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you wrap larger quantites of text?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you wrap larger quantites of text?
In XL2003 the maximum number of characters that can be displayed in a cell
is 1,024, you can have over 32,000 in a cell, but only 1024 will be visible on the screen. I'm not sure if that's different in XL2007. Could that be the problem? Regards, Alan. "Coke" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you wrap larger quantites of text?
Try using Alt+F11
If this post helps click Yes --------------- Jacob Skaria |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you wrap larger quantites of text?
alt-f11 takes me into the VBE when I'm not editing a cell.
And doesn't do anything when I am editing a cell. Maybe this response was meant for another question??? Jacob Skaria wrote: Try using Alt+F11 If this post helps click Yes --------------- Jacob Skaria -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get date/time to wrap (format - wrap text doesn't work)? | Excel Discussion (Misc queries) | |||
options list box - larger text | Excel Worksheet Functions | |||
Wrap text doesn't wrap | Excel Worksheet Functions | |||
"Wrap text" makes row larger than text resulting in white space. | Excel Discussion (Misc queries) | |||
Merging different quantites of labels based on Excel data | Excel Worksheet Functions |