Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
מוטי
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
tony h
 
Posts: n/a
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
How do you write 2 lines of text in 1 cell rather than use 2 cells !!!help!!! Excel Discussion (Misc queries) 5 September 20th 05 06:05 PM
Text lines in a cell kboec Excel Discussion (Misc queries) 3 August 31st 05 08:26 AM
Text in formula bar is not displaying in cell Mike Excel Discussion (Misc queries) 0 August 29th 05 09:47 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM


All times are GMT +1. The time now is 11:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"