How to enter text in two line in a excel cell
 

Hey Giggs,

Could you help me to enter 2 lines text in a excel cell without using space
bar. Like we can write in Word. By pasting the texts coped from word, it
works, but i wanna know whether we can enter 2 line texts in an excel single
cell.

Thanks

How to enter text in two line in a excel cell
 

Alt+Enter, and format/cells/alignment to permit word wrap.
--
David Biddulph

"Pra" wrote in message
...
Hey Giggs,

Could you help me to enter 2 lines text in a excel cell without using
space
bar. Like we can write in Word. By pasting the texts coped from word, it
works, but i wanna know whether we can enter 2 line texts in an excel
single
cell.

Thanks

How to enter text in two line in a excel cell
 

Separate them with Alt-Enter

--
__________________________________
HTH

Bob

"Pra" wrote in message
...
Hey Giggs,

Could you help me to enter 2 lines text in a excel cell without using
space
bar. Like we can write in Word. By pasting the texts coped from word, it
works, but i wanna know whether we can enter 2 line texts in an excel
single
cell.

Thanks