Excel Wrap text question

[johannesd]

If I have a long description type text in a Cell, with Wrap Text turned on, I would like to force a 'line break' within the cell.

How do I do that? (at the moment, I type spaces until the intened second line text jumps to the second line, or resize the column until it does.. there must be a better way..?)

For example, I'd like to have the following in one cell (without merging cells), in the following format, without having to rely on the column width or spacing to force Line2 to start on Line 2 etc..

Line1 bla bla
Line2 bla bla
Line3 bla bla

Thanks!!

 

[xlbo]

Use Alt+Enter where you want your line break
This is the 1st line -----press Alt+Enter
This is the 2nd line -----press Alt+Enter

etc etc
HTH
Geoff

 

[johannesd]

Great, it works! Thanks.

I can't believe I've struggled with something so simple, for so long (couldn't locate it in help either..!!). Thanks again.