How to Insert a Diagonal Line to a Cell in Microsoft Excel

It’s not very common that you would want to add a diagonal line to a cell in your Excel document. But definitely, there could be occasions where you want to add a diagonal line in the very first cell of an Excel file. You might want to divide the cell into 2 and add 2 different headers inside both the divided halves. Whatever be your requirement, the solution is simple.

Read on, to learn how you can easily add a diagonal line inside a cell in your Excel document and to add text inside the diagonally divided cell.

How to Add a Diagonal Line in a Cell in Microsoft Excel

Step 1: Firstly, click on the cell that you want to add a diagonal line to.

 

1 Blank Cell Min

 



Step 2: Then click on the HOME tab at the top and click on the Borders icon. From the dropdown menu that appears, click on the More Borders option.

 

2 More Borders Min

 

Step 3: You will now have the Format Cells window open before you. Click on the Border tab at the top.

As next, click on the diagonal border button. Click on the OK button once you are done.

 

3 Border Tab Min

 

Step 4: You can now see that a diagonal line is successfully added to the cell you selected.

If you would like to format this diagonal border a bit, click on the Borders button again under the HOME tab.

From the menu that drops down, click on More Borders option one more time.

 

4 More Borders Min

 

Step 5: In the Format Cells window, you can choose the style of the border. You can make your line really thick or thin or dotted. You also have the option to choose a color for your border.

If you would like to add an outline border as well, in addition to your diagonal border, click on the Outline icon.

Finally, click on the diagonal border icon once again to apply all your formatting to the diagonal border.

Once you are all done, hit the OK button.

 

5 Styling Border Min

 

Step 6: That’s it. If you now look at your cell, you can see that all your formatting are successfully applied to the cell you selected. Enjoy!

 

6 Final Result

 

How to Add Text Inside a Diagonally Divided Cell in Microsoft Excel

Step 1: Firstly, double click on the cell that is diagonally divided.

 

1 Click Cell

 

Step 2: As next, type in the first header and then press the ALT + ENTER keys together to go to the new line. In the next line, type in the second header.

 

2 Header

 

Step 3: If you press elsewhere, you can see that the second header is struck off. To fix that, double click on the cell again.

 

3 Allign



 

Step 4: Now press the SPACE bar before the second header and move it to the right corner.

 

4 Alligned

 

Step 5: Now if you click elsewhere, you can see that your headers are neatly arranged inside your diagonally divided cell.

 

5 Final Result

 

Please tell us in the comments section whether you found the article helpful. Stay tuned for more tricks, how-tos, and tips.