Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling "wrap text" neuters alt-return line feeds within cell
Hello,
The online help for Microsoft Excel 2003 says to disable wrap-text in order not to have wrapping of long lines within cells. However, doing this also turns line feeds into non-line-feed characters (some kind of strange symbol serving as a place-holder for the linefeed). I only want to disable wrapping of long lines, I don't want to remove the effect of hard coded line feeds. How is this done in Excel? (If it can't be done, that would also be helpful to know). Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling "wrap text" neuters alt-return line feeds within cell
If you have wraptext enabled, then you'll get a new line within the cell for
each alt-enter. And excel will break any line that's too long whereever it wants. If you turn off wraptext, then the alt-enters will appear as little squares. But there isn't a middle ground. wrote: Hello, The online help for Microsoft Excel 2003 says to disable wrap-text in order not to have wrapping of long lines within cells. However, doing this also turns line feeds into non-line-feed characters (some kind of strange symbol serving as a place-holder for the linefeed). I only want to disable wrapping of long lines, I don't want to remove the effect of hard coded line feeds. How is this done in Excel? (If it can't be done, that would also be helpful to know). Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling "wrap text" neuters alt-return line feeds within cell
Dave Peterson wrote: If you have wraptext enabled, then you'll get a new line within the cell for each alt-enter. And excel will break any line that's too long whereever it wants. If you turn off wraptext, then the alt-enters will appear as little squares. But there isn't a middle ground. Thanks, Dave. Fred wrote: Hello, The online help for Microsoft Excel 2003 says to disable wrap-text in order not to have wrapping of long lines within cells. However, doing this also turns line feeds into non-line-feed characters (some kind of strange symbol serving as a place-holder for the linefeed). I only want to disable wrapping of long lines, I don't want to remove the effect of hard coded line feeds. How is this done in Excel? (If it can't be done, that would also be helpful to know). Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two cells and return certain value in third cell | Excel Worksheet Functions | |||
Return value in cell above the reference | Excel Discussion (Misc queries) | |||
Return entry in column above/below cell | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |