This blog post shows you that how to split cells diagonally in Excel.
This situation comes when creating reports or dashboards with data in Excel and the need to split cells diagonally.
Split Cells Diagonally
The purpose of split cells diagonally is to add two heading in a single cell – one for rows and another for columns data.
See the image below:-
Now we will use step by step procedure to add a diagonal line in a cell.
Step 1 – Click on the cell, which needs to be split diagonally, in this example cell “A1”.
Step 2 – And press CTRL + 1 here as the keyboard shortcut or Right-click from the mouse and select “Format Cells” from right-click properties.
You will find the below image:-
Go to the “Border” tab here
Here you can see the preview of the selected cell.
Click the extreme below right side box, spitted diagonally.
Once you click on this option, your cell is split diagonally, see in the preview cell which you want to split.
If you want to split multiple cells diagonally then select all the cells and use the same method.
In the “Format Cells” dialogue box, you can apply multiple formatting into the selected cell.
Such as borderlines – use it as dotted, double dotted, or color the border of the cell.
Also can change the font size by increasing or decreasing.
You can pick the formatting options here which you want to see in your selected cell.
Step 3 – Press “Ok”.
The selected cell is now split diagonally.
Adding Two Headings in One Cell
Now next step is to add headings in the split cell.
As per the dataset, our first heading is “Zones” and the second heading is “Months”.
Follow the adding heading procedure step by step
Step1 – Double click on the split cell or press “F2” from the keyboard to bring the cell into edit mode.
Step 2 – Type “Zones” as the first heading and after that press here “ALT + Enter” to send the cursor into the second line in the same cell.
Step 3 – And type “Months” into the second line.
And here you can do some formatting for the cell, such as bold text, etc.
And after that press “Enter”.
See that your two headings have been inserted in the same cell.
You can now do some formatting here, like change font size, change row or column width, or change the upper and lower alignment.
See the image below:-
How to Adjust Heading into One Cell
Now press “F2” into the split cell to turn it into the edit mode.
Put the cursor before heading “Zones” and press some spacebar to move it a little bit towards the right side.
And press Enter now.
See that the heading has been adjusted as per your requirement.
Now you can see that both the heading are inserted in one cell successfully.
Remove Diagonal Line from the Cell
Now if you want to remove the diagonally split lines from the cell then use the same method again here.
Press “CTRL + 1” on the split cell or right-click from the mouse and select the “Format Cells” option from right-click properties.
Go to the “Border” tab and click on the “None” option here to remove the diagonal line from the cell.
And press “Ok”, see that the diagonal line is removed now.
If you want to learn more about this, please visit Microsoft Office Support.
I hope you find this tutorial useful.
Please feel free to put your comments or suggestion in the comment box below.