MrExcel's Learn Excel #790 - Split Cell

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 15, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top