| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
two lines of text in a single row?
I would like to enter two lines of text in a single row (using ALT-ENT), but
I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks |
|
#2
|
|||
|
|||
|
You will have to widen the column
-- Don Guillett SalesAid Software "SteveB" wrote in message ... I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks |
|
#3
|
|||
|
|||
|
That is one option, but in this case I can't widen the columns. I made a
calendar and the columns need to remain a uniform width. Any other thoughts? Thanks Steve "Don Guillett" wrote: You will have to widen the column -- Don Guillett SalesAid Software "SteveB" wrote in message ... I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks |
|
#4
|
|||
|
|||
|
Once you use alt-enter, the wraptext property is set to on. This means the text
won't spill over into the adjacent cell. If you turn off the wraptext (format|cells|alignment tab), then your alt-enters will turn to little boxes and you won't see separate lines within the cell. Maybe you can change the font to something smaller??? Or even Format|cells|alignment tab|shrink to fit??? SteveB wrote: That is one option, but in this case I can't widen the columns. I made a calendar and the columns need to remain a uniform width. Any other thoughts? Thanks Steve "Don Guillett" wrote: You will have to widen the column -- Don Guillett SalesAid Software "SteveB" wrote in message ... I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks -- Dave Peterson |
|
#5
|
|||
|
|||
|
Yes, that is what I found as you described in first two paragraphs. Problem
is my columns are only 3 units wide. Even typing my name in a cell spills across 2 columns. I am using 10 font, and don't want to go much smaller. Shrink to fit definately is too small. (My eyes aren't what they used to be you know). Any other ideas? thanks Steve "Dave Peterson" wrote: Once you use alt-enter, the wraptext property is set to on. This means the text won't spill over into the adjacent cell. If you turn off the wraptext (format|cells|alignment tab), then your alt-enters will turn to little boxes and you won't see separate lines within the cell. Maybe you can change the font to something smaller??? Or even Format|cells|alignment tab|shrink to fit??? SteveB wrote: That is one option, but in this case I can't widen the columns. I made a calendar and the columns need to remain a uniform width. Any other thoughts? Thanks Steve "Don Guillett" wrote: You will have to widen the column -- Don Guillett SalesAid Software "SteveB" wrote in message ... I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks -- Dave Peterson |
|
#6
|
|||
|
|||
|
If I had to have this, I'd bite the bullet and use MergedCells (ugh!).
But maybe you could do something else. Put that long string into another cell. Make it look exactly the way you want (use whatever width you want). Now Edit|Copy that cell. Back to the "real" location shift-edit|Paste Picture Link Now you have a picture that can overflow into the adjacent cell. (I'm not sure which one I'd hate more--the picture or the mergedcell!) SteveB wrote: Yes, that is what I found as you described in first two paragraphs. Problem is my columns are only 3 units wide. Even typing my name in a cell spills across 2 columns. I am using 10 font, and don't want to go much smaller. Shrink to fit definately is too small. (My eyes aren't what they used to be you know). Any other ideas? thanks Steve "Dave Peterson" wrote: Once you use alt-enter, the wraptext property is set to on. This means the text won't spill over into the adjacent cell. If you turn off the wraptext (format|cells|alignment tab), then your alt-enters will turn to little boxes and you won't see separate lines within the cell. Maybe you can change the font to something smaller??? Or even Format|cells|alignment tab|shrink to fit??? SteveB wrote: That is one option, but in this case I can't widen the columns. I made a calendar and the columns need to remain a uniform width. Any other thoughts? Thanks Steve "Don Guillett" wrote: You will have to widen the column -- Don Guillett SalesAid Software "SteveB" wrote in message ... I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks -- Dave Peterson -- Dave Peterson |
|
#7
|
|||
|
|||
|
Why don't you use comments? Since they "float" above the cells they
shouldn't interfere with your calendar. I know it's not what you wanted to do in the first place, but I thought it might help. "SteveB" wrote: I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks |
|
#8
|
|||
|
|||
|
Thanks for the idea, I tried it. Similar to using a text box, but then I
have the arrow that shows and I have to do extra formatting to turn off fill, etc. I made a calander in excel, and the text I enter are notes about the events. The text is printed with the calendar and needs to be as compact as possible. thanks "Sloth" wrote: Why don't you use comments? Since they "float" above the cells they shouldn't interfere with your calendar. I know it's not what you wanted to do in the first place, but I thought it might help. "SteveB" wrote: I would like to enter two lines of text in a single row (using ALT-ENT), but I don't want to merge cells. It's ok if the text spills across adjacent columns. And I don't want the text to wrap. Any ideas? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two lines of text in single row | Excel Discussion (Misc queries) | |||
| 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) | |||
| how many lines can be in wrap text within a cell? | Excel Worksheet Functions | |||
Hybrid Mode
