how do i make text fit into 1 block in 2 or more lines in Excel
 

i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't work.

how do i make text fit into 1 block in 2 or more lines in Excel
 

FormatCellsAlignment tab, check Wrap text

--
Kind regards,

Niek Otten

"Siwelile" wrote in message
...
i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't
work.

how do i make text fit into 1 block in 2 or more lines in Excel
 

You can force text to wrap by inserting the vertical bar symbol "|"
(above the backslash on most US keyboards.) You may have to adjust the
cell height to see the second line.

---Glenn


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=509325

how do i make text fit into 1 block in 2 or more lines in Excel
 

Sorry, I guess my age is showing, I was thinking 1-2-3. Use Alt-Enter
to force the line wrap within a cell in Excel...


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=509325