In case you have selected multiple cells, this would insert the diagonal line in all the selected cells. The above steps would insert a diagonal line within the selected cell. This will also show you the live preview of how the cell would look like In the Border section, click on the diagonal line icon at the bottom right of the section (as shown below).In the Format cells dialog box, click on the ‘Border’ tab.In the Font group, click on the dialog box launcher icon (the small, tilted arrow at the bottom right of the group).Select the cell in which you want to insert the line (which is cell A1 in our example).Suppose you have a data set as shown below and you want to insert a diagonal line in cell A1. So let’s get started! Inserting a Diagonal Line in Excel

In this tutorial, I would show you how quickly split a cell diagonally in Excel. This is helpful when you want to show two separate headings within the same cell – one for the row and one for the column (as shown below in cell A1).Īnd being the super awesome spreadsheet tool that Excel is, there is an inbuilt way to easily insert a diagonal line within a cell in Excel.

When working with data in Excel and creating reports/ dashboards, sometimes you would have a need to split a cell diagonally.

Angle text in excel