Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get multiple lines of text in a Excel cell?
Hi,
This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#2
|
|||
|
|||
I suspect you mean Alt+Enter? That puts a carriage return within the cell.
************ Anne Troy www.OfficeArticles.com "Tene" wrote in message ... Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#3
|
|||
|
|||
alt+enter
"Tene" wrote: Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#4
|
|||
|
|||
one way
ctrl+enter will start a new line HTH "Tene" wrote: Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#5
|
|||
|
|||
<format<cells<alignment select wrap text
to force a line break alt-enter "Tene" wrote: Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#6
|
|||
|
|||
Hi Tene
Use Alt-Enter -- Regards Ron de Bruin http://www.rondebruin.nl "Tene" wrote in message ... Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#7
|
|||
|
|||
When you reach the break point, hit Alt and Enter together,
Regards, Alan. "Tene" wrote in message ... Hi, This question drives me insane each time I use Excel, stupidly I don't write it down because its under help, but now I can't find it. So, could you please tell me how I can achieve multiple lines of text within a cell Thanks from an idiot! Tene |
#8
|
|||
|
|||
thanks everyone!
Tene |
#9
|
|||
|
|||
And if that's not enough, try Alt+Enter. LOL!!
************ Anne Troy www.OfficeArticles.com "Tene" wrote in message ... thanks everyone! Tene |
#10
|
|||
|
|||
or Enter + Alt even!
"Anne Troy" wrote in message ... And if that's not enough, try Alt+Enter. LOL!! ************ Anne Troy www.OfficeArticles.com "Tene" wrote in message ... thanks everyone! Tene |
#11
|
|||
|
|||
1) format the cell as text 2) click the alignment tab 3) directly under the heading Text Control there is a wrap text check box. 4) click on the check box. (a check should appear in it) 5) click ok 6) save your work, text wrap is now on for that cell or range of cells this works for me every time Paul -- ppete83606 ------------------------------------------------------------------------ ppete83606's Profile: http://www.excelforum.com/member.php...o&userid=26953 View this thread: http://www.excelforum.com/showthread...hreadid=466395 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions |