close

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

Insert Alt-Enter between the text.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;????quot; gt; wrote in message
...
gt; Hello,
gt; I would like to know how can i write 2 lines of text in one cell?
gt; i know that if i write a long sentence and wrap the text it will look the
same
gt; but there is another way?
gt;
gt; thanks
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.comquot;????quot; gt; wrote in message
...
gt; Hello,
gt; I would like to know how can i write 2 lines of text in one
gt; cell?
gt; i know that if i write a long sentence and wrap the text it
gt; will look the same
gt; but there is another way?
gt;
gt; thanks

use lt;altgt;lt;entergt; between the lines
regards--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=526693Wherever you want to line to break, hold down the Alt key and press Enter

Waya con Dios,
Chuck, CABGx3
quot;????quot; gt; wrote in message
...
gt; Hello,
gt; I would like to know how can i write 2 lines of text in one cell?
gt; i know that if i write a long sentence and wrap the text it will look the
same
gt; but there is another way?
gt;
gt; thanks

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()