ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can i write 2 lines of text in one cell? (https://www.excelbanter.com/excel-discussion-misc-queries/79786-how-can-i-write-2-lines-text-one-cell.html)

מוטי

How can i write 2 lines of text in one cell?
 
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

How can i write 2 lines of text in one cell?
 
Insert Alt-Enter between the text.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"????" wrote in message
...
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




Chip Pearson

How can i write 2 lines of text in one cell?
 
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


"????" wrote in message
...
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




tony h

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

use <alt<enter between the lines
regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=526693


CLR

How can i write 2 lines of text in one cell?
 
Wherever you want to line to break, hold down the Alt key and press Enter

Waya con Dios,
Chuck, CABGx3



"????" wrote in message
...
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





All times are GMT +1. The time now is 06:00 AM.

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