Kathy asks how to type numbers in a diagonally split cell. Episode 790 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
MrExcel's Learn-XL #790 - Split Cell.
Hey, welcome back to the MrExcel netcast, I'm Bill Gelen.
Today, a question from Kathy in Milwaukee. You know, every once in a while, we get these crazy requests from our manager, and this certainly qualifies as one of those.
The manager wants two values in a cell, split with the diagonal.
So, Kathy was able to use Format Cells, went to the Border Tab and basically turned on this diagonal and then was able to type in one number or so-- for example, 244.
You know, that appears on the right side of the diagonal, but she wants to know how can I enter data above the diagonal.
Well, we have to use a couple of tricks here.
I'm going to type 33-- that'll be the number above the diagonal-- and then we have to press Alt+ENTER-- Alt+ENTER-- and then a couple of spaces.
So, basically, that 33 is going to go to the left.
Want to press enough spaces to get the 44 over to the right, press 44-- and you're going to have to play with this a little bit, you're going to have to figure out the right number of spaces I'm gonna add to this-- put a couple more spaces in, and it starts to look okay.
This cell's too high now-- Format Row Height, we'll go to 26 and start to get the desired effect.
Now, the huge problem with this, is we'll never be able to add up either the 33 or the 44.
The cell is, basically, now just a Text Cell.
It certainly could be appropriate if this is, absolutely, the way that your manager wants to see these numbers-- 33 and 44.
Just understand that, from a mathematical point of view, we're never going to be able to total these.
Total the numbers above, do any kind of math with them, without going through some extraordinary left and right types of commands.
So, setting up a split cell is certainly a trick that I've seen once or twice before.
If you absolutely need to do it, use Alt+ENTER to separate the left number, and then a bunch of spaces to get the second number down close to the right margin.
Well, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
Hey, welcome back to the MrExcel netcast, I'm Bill Gelen.
Today, a question from Kathy in Milwaukee. You know, every once in a while, we get these crazy requests from our manager, and this certainly qualifies as one of those.
The manager wants two values in a cell, split with the diagonal.
So, Kathy was able to use Format Cells, went to the Border Tab and basically turned on this diagonal and then was able to type in one number or so-- for example, 244.
You know, that appears on the right side of the diagonal, but she wants to know how can I enter data above the diagonal.
Well, we have to use a couple of tricks here.
I'm going to type 33-- that'll be the number above the diagonal-- and then we have to press Alt+ENTER-- Alt+ENTER-- and then a couple of spaces.
So, basically, that 33 is going to go to the left.
Want to press enough spaces to get the 44 over to the right, press 44-- and you're going to have to play with this a little bit, you're going to have to figure out the right number of spaces I'm gonna add to this-- put a couple more spaces in, and it starts to look okay.
This cell's too high now-- Format Row Height, we'll go to 26 and start to get the desired effect.
Now, the huge problem with this, is we'll never be able to add up either the 33 or the 44.
The cell is, basically, now just a Text Cell.
It certainly could be appropriate if this is, absolutely, the way that your manager wants to see these numbers-- 33 and 44.
Just understand that, from a mathematical point of view, we're never going to be able to total these.
Total the numbers above, do any kind of math with them, without going through some extraordinary left and right types of commands.
So, setting up a split cell is certainly a trick that I've seen once or twice before.
If you absolutely need to do it, use Alt+ENTER to separate the left number, and then a bunch of spaces to get the second number down close to the right margin.
Well, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
