Home |
Search |
Today's Posts |
#1
|
|||
|
|||
two lines of text in single row
How do I enter two lines of text in a single row - w/o merging cells?
Ok if the text spreads across adjacent columns. Currently, if I turn off wrap text, both lines stay on one line with a pipe symbol. If I turn on wrap text, the text tries to wrap in the single cell. I can't expand the cell to accomodate all the text. |
#2
|
|||
|
|||
SteveB wrote:
How do I enter two lines of text in a single row - w/o merging cells? Ok if the text spreads across adjacent columns. Currently, if I turn off wrap text, both lines stay on one line with a pipe symbol. If I turn on wrap text, the text tries to wrap in the single cell. I can't expand the cell to accomodate all the text. ---------------------- If I understand your problem correctly then turn off word wrap. Enter your text into the left most cell and when you come to where you want the second line to start use "Alt-Enter" and keep typing. Excel will recognize the Alt-Enter as a CRLF within that one cell and format it as two lines that extend to the right as far as necessary (unless you have another active cell off to the right somewhere). Good luck.... Bill |
#3
|
|||
|
|||
Steve
Type a line then ALT + ENTER, type another line then ENTER. ALT + ENTER is a carriage return in-cell. Gord Dibben Excel MVP On Tue, 17 May 2005 10:32:01 -0700, SteveB wrote: How do I enter two lines of text in a single row - w/o merging cells? Ok if the text spreads across adjacent columns. Currently, if I turn off wrap text, both lines stay on one line with a pipe symbol. If I turn on wrap text, the text tries to wrap in the single cell. I can't expand the cell to accomodate all the text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change two lines of text data to one | Excel Discussion (Misc queries) | |||
Pie chart with 'anchored' lines to text box | Charts and Charting in Excel | |||
Can delimited text file imports be extracted to a single column i. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
how many lines can be in wrap text within a cell? | Excel Worksheet Functions |