Disabling "wrap text" neuters alt-return line feeds within cell

  • Thread starter Thread starter Mister.Fred.Ma
  • Start date Start date
M

Mister.Fred.Ma

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.
 
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.
 
Dave said:
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.
Click to expand...

Thanks, Dave.

Fred
 
Back
Top