The fact is, you can’t split a cell diagonally into two in excel but you can make it look like it is split as shown in above image.
Let’s say you have conducted a survey in different areas to know the population of several age groups. In cell A1 you have written “Age Range Area”. You want Excel to split cell into two, to show “Age Range” for Column Headings and “Area” for Row Headings.
First let’s split the Cell A1 into two. Now to split a cell in half in excel 2016 we will use an excel trick. Follow the steps below:
Select A1.
Go to the formula bar and place your cursor between “Age Range” and “Area”.
Hit Alt+Enter, Repeat this until you are satisfied with the result.
Now it looks good. This is a makeshift in excel to split a cell in half diagonally. You can’t actually work on both parts but visually it looks split.
Related Articles:
Scientific formatting in Excel
How To Switch Rows and Columns in Excel
How to Use the Custom Format Cell in Excel
Excel convert decimal Seconds into time format
Popular Articles:
50 Excel Shortcut to Increase Your Productivity
How to Use SUMIF Function in Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Add spaces? Seriously?
If you have any better way, please share. We will include it here.
I think I may have found a slightly more robust solution, depending on your goal.
I was attempting to create the appearance of a diagonal split in order to show a fraction, like a completion percentage. This meant that I wanted both the top and bottom portions of the cell to be formulas, rather than just text. Since it appears excel does not tolerate adding multiple formulas in a single cell, I had to get creative.
For this case, rather than using a single cell and the alt+enter trick to move the text, I used a 2x2 block of cells. In the top left cell, I entered the formula for my numerator [lets say '=SUM(A1:A10)]. In the bottom right cell, I entered the formula for my denominator ['=SUM(B1:B10)]. Then in the two remaining cells, I simply added the diagonal border as you described above, but going the opposite direction.
The most difficult part was actually splitting the cell into four cells. I ended up having to add another row and column and then merge them all except for the one with the fraction in it.
That's a good workaround.
This is fantastic tip! I would put the diagonal going the other way though.