Just moved from 2010 to 2013, learning it's differences. I'm having an issue with wanting to put two lines in a cell. I put my first line, then do Alt Enter for my second line. When I click out of the cell, the cell automatically wraps (NOT what I want). if I turn off Wrap, both lines are shown as a single line in the cell, though they're still two lines in the formula bar.
How do I get two lines to show in my spreadsheet, without wrapping?
How can you get text to wrap without wrapping text? You can't.How do I get two lines to show in my spreadsheet, without wrapping?
Entia non sunt multiplicanda sine necessitate
That's actually a unique thing, something I never noticed before and can confirm the same behavior I see also in 2013.
But your saying that behavior is actually different in 2010? In 2010, you could use Alt Enter for a line break in a Cell and the info above it did not wrap?
A text box will behave differently and will not wrap the info, but don't think that is what you want. It seems you want to almost treat 1 cell as if it was 2 or more using Alt-Enter for the line breaks?
I think you misunderstand. I want two lines of text, one under the other, in a cell. Normal behavior of typing Text in a cell is that if the line is longer than the cell, the extra text spills over into the next cell (unless it has data in it). So, if I have two lines of text in the same cell (separated by Alt-Enter), they should display as two lines, and if they're too long they should spill over to the next cell. That's the behavior I'm used to. But what I'm seeing now is the lines are wrapping. If I UnWrap, they display as a single line, though the formula bar still shows them as two lines.
I've attached a picture I hope will make it clearer. Cell F2 and F4 don't have wrapping turned on. F4 and G6 both have Alt-Enter applied. In F4 it displays as a single line. To get G6 to show as two lines I have to do Wrap and widen my cell. I want it to spill over in the same way F3 spills over, but with two lines.
Last edited by jomili; 04-29-2016 at 01:39 PM.
Excel has never behaved that way, in my recollection.they should display as two lines, and if they're too long they should spill over to the next cell.
Last edited by shg; 04-29-2016 at 01:39 PM.
Well, I can't roll back to 2010 to compare, but I could swear that's the way it worked for me.
I'm looking at it right now, and it doesn't. Neither does Excel 2003.
No that is not how it works/worked. There is no way to type stuff in 1 cell and have parts of it go into another cell.Normal behavior of typing Text in a cell is that if the line is longer than the cell, the extra text spills over into the next cell (unless it has data in it)
What you experienced before was just that row height adjusting to accommodate 2 lines of text in teh same cell
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I guess I'm still not making myself clear. The text doesn't actually "go into another cell", but visually it appears the line of text crosses the other cells, in the same way it does when you type a long line of text into a cell; the text "appears" to flow into the following cells, because wrapping is NOT turned on.
The situation I have no is that I have a cell that requires two lines of text, but the cell can't be widened (report reasons), and another row can't be added. So, I need two lines of text in the cell, but I don't want to wrap that text, I want the text to exceed the limits of the cell in the same a single line does.
Not going to happen.
Can you use 2 rows for your text and then in the cell to the right of them merge them verically to look like one cell? That would give the desired visual effect.
Unless you fiddle with formatting the rest of the row/s and use Wrap, then there is no way to type data into 1 cell, and have only part go into that cell, and the rest into another cell
ptmuldoon,
If I could use 2 cell rows I wouldn't need to do anything else; if you type a line of text in an Excel cell that's too long for that cell, and you DON'T turn wrapping on, the text "appears" to flow into the following cells. So, in both of my cell rows, the text would spill over the way I want it to.
FDibbons,
I beg to differ, unless you're not understanding what I'm saying. See the picture I posted. Look at the example in F2, then reexamine your statement "there is no way to type data into 1 cell, and have only part go into that cell, and the rest into another cell":
My situation is I want two lines in my one cell to act in the same way a single line in that cell would. I'm sure I used to do it in Excel 2003 and 2010, but I'm becoming more and more convinced that was just a figment of my fevered imagination.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks