ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No wrapping, but keep line breaks (https://www.excelbanter.com/excel-discussion-misc-queries/182037-no-wrapping-but-keep-line-breaks.html)

Paul

No wrapping, but keep line breaks
 
I want text in a cell to not wrap around on its own. However, I want
manual line breaks (alt-Enter) to still start a new line in the cell.
Is there a way to do this?

Thx.

Dave Peterson

No wrapping, but keep line breaks
 
If you make the columnwidth too skinny, you can't stop the automatich linewrap.

If you only want wraps at alt-enters, you'll have to make the column as wide as
you need it.

Paul wrote:

I want text in a cell to not wrap around on its own. However, I want
manual line breaks (alt-Enter) to still start a new line in the cell.
Is there a way to do this?

Thx.


--

Dave Peterson

Paul

No wrapping, but keep line breaks
 
OK, thanks for letting me know.

On Apr 1, 3:58 pm, Dave Peterson wrote:
If you make the columnwidth too skinny, you can't stop the automatich linewrap.

If you only want wraps at alt-enters, you'll have to make the column as wide as
you need it.

Paul wrote:

I want text in a cell to not wrap around on its own. However, I want
manual line breaks (alt-Enter) to still start a new line in the cell.
Is there a way to do this?


Thx.



All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com