How can i write 2 lines of text in one cell?

[Guest]

Hello,
I would like to know how can i write 2 lines of text in one cell?
i know that if i write a long sentence and wrap the text it will look the same
but there is another way?

thanks

 

[Bob Phillips]

Insert Alt-Enter between the text.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Chip Pearson]

You can create a new line in a cell by typing ALT ENTER.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[tony h]

use <alt><enter> between the lines
regards

 

[CLR]

Wherever you want to line to break, hold down the Alt key and press Enter

Waya con Dios,
Chuck, CABGx3