How to Split Cells Diagonally in Excel (Step by Step Guide)

Split Cells Diagonally

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:-

Split Cells Diagonally
Split Cells Diagonally – Image-01

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:-

 Split Cells Diagonally
Split Cells Diagonally – Image-02

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”.

Split Cells Diagonally
Split Cells Diagonally – Image-03

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:-

 Split Cells Diagonally
Split Cells Diagonally – Image-04

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.

Split Cells Diagonally
Split Cells Diagonally – Image-05

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.

Split Cells Diagonally
Split Cells Diagonally – Image-06

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.

Thanks

Related Post

How to Remove Formulas and Keep the Values in Excel (4 Quick Ways)

3 Easy Ways to Select the Visible Cells Only In Excel

How to Highlight Every Other Row or Column in Excel

How to Insert Blank Rows after Every (2nd or 3rd or nth) Row in Excel

5 Ways to Delete Blank Rows in Excel (With VBA Macro)

How to Change the Background Colors in Excel VBA

How to Wrap Text in Excel – 4 Easiest Method

Leave a Comment

Your email address will not be published. Required fields are marked *