Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple lines in a cell
Does anyone know how to put multiple lines in a cell that is high enough for
more than one line? charles arnett |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple lines in a cell
At the end of your line hit alt-enter
"charles" wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple lines in a cell
charles Wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett Two possibilities: 1) When you're typing, hit ALT-ENTER to keep typing on a new line for the same cell. 2) If you just want the text to wrap to the next line when you're typing, go to Format - Cells... Select Alignment, check off the Wrap text cell, and hit OK. (As long as you haven't merged the cell, it will automatically resize. If you've merged, you'll possibly have to manually resize the cell.) Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=564298 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple lines in a cell
Right-click and select Format Cells, then in the Alignment tab tick the Wrap
text box under Text contol. Hope this helps. Tara "charles" wrote: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple lines in a cell
alt+enter
"charles" escreveu: Does anyone know how to put multiple lines in a cell that is high enough for more than one line? charles arnett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put an adress in a cell in multiple lines?? | Excel Discussion (Misc queries) | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
HOW CAN I TYPE MULTIPLE LINES IN A CELL | Setting up and Configuration of Excel | |||
how do I enter multiple lines in a cell in Excel | Excel Discussion (Misc queries) |