ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Alt-Enter Line Breaks (https://www.excelbanter.com/excel-discussion-misc-queries/244821-alt-enter-line-breaks.html)

Keven Denen

Alt-Enter Line Breaks
 
Alt-Enter works fine to create a line break in the middle of a cell.
The problem I run into is when I link to that cell somewhere else in
the workbook, the line breaks don't show up in the new cell. Anyone
know how to make this work?

I'm working with Excel 2003.

Keven

Dave Peterson

Alt-Enter Line Breaks
 
Make sure that the receiving cell has wraptext enabled.

Format|cells|alignment tab
is where you'd find this option.



Keven Denen wrote:

Alt-Enter works fine to create a line break in the middle of a cell.
The problem I run into is when I link to that cell somewhere else in
the workbook, the line breaks don't show up in the new cell. Anyone
know how to make this work?

I'm working with Excel 2003.

Keven


--

Dave Peterson

Keven Denen

Alt-Enter Line Breaks
 
On Oct 7, 9:30*am, Dave Peterson wrote:
Make sure that the receiving cell has wraptext enabled.

Format|cells|alignment tab
is where you'd find this option.

Keven Denen wrote:

Alt-Enter works fine to create a line break in the middle of a cell.
The problem I run into is when I link to that cell somewhere else in
the workbook, the line breaks don't show up in the new cell. Anyone
know how to make this work?


I'm working with Excel 2003.


Keven


--

Dave Peterson


Wow, I can't believe it was that easy. Now I feel foolish...


All times are GMT +1. The time now is 12:04 AM.

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