How To Draw A Diagonal Line In Excel

When working with data in Excel and creating reports/dashboards, sometimes y'all would have a need to dissever a cell diagonally.

This is helpful when you want to evidence ii separate headings within the same cell – 1 for the row and ane for the column (as shown below in cell A1).

And being the super awesome spreadsheet tool that Excel is, there is an inbuilt manner to easily insert a diagonal line within a cell in Excel.

In this tutorial, I would show you lot how quickly carve up a jail cell diagonally in Excel.

And so let's get started!

Inserting a Diagonal Line in Excel

Suppose yous have a information prepare as shown below and you want to insert a diagonal line in cell A1.

Beneath are the steps to do this:

Select the jail cell in which y'all want to insert the line (which is prison cell A1 in our example)
Click the Dwelling house tab
In the Font group, click on the dialog box launcher icon (the pocket-size, tilted arrow at the lesser correct of the group)
In the Format cells dialog box, click on the 'Border' tab
In the Edge section, click on the diagonal line icon at the bottom right of the section (as shown below). This will also bear witness you the live preview of how the cell would look like
Click Ok

The above steps would insert a diagonal line within the selected cell. In case you have selected multiple cells, this would insert the diagonal line in all the selected cells.

You can also customize the line that is inserted.

For instance, you can choose the thickness of the line or the color of the line that should be inserted in the cell. The setting is right there in the format cells dialog box inside the border group (as highlighted below).

You lot first need to make the Style and Color selections (if needed) and then click on the diagonal border icon.

You can also utilize the aforementioned method to insert a diagonal line in merged cells.

Now that we accept the diagonal line in the cell, all yous have to do is insert the text for the two headers and space information technology out a little bit to make it look as if it's separated past the tilted line.

Permit's say I want to insert the header 'Month' at the pinnacle and 'Land' at the lesser within the same cell.

Beneath are the steps to do this:

Select the jail cell that already has the diagonal line
Double click on the prison cell, or press the F2 key on your keyboard to get into the edit mode
Enter the text 'Month' (which is the header title for the kickoff row)
While still being in the edit way, concur the ALT key and printing the Enter key (or Choice + Enter cardinal if you lot're using Mac). This volition insert a line interruption and take your cursor to the next line within that same cell
Enter the text 'Country' (which is the header title for the first cavalcade)
Conform the formatting (such as brand it bold, align text to the left, increase the row pinnacle), and add some space characters earlier the 'Month' header to push button it a picayune to the correct

The above steps would insert two headers in the same cell and make it appear that these are being divided by a diagonal line.

How to Remove the Diagonal Line in the Cell

If you desire to get rid of the line within the cell, just follow the same steps and you can remove it in the same Format Cells dialog box.

In the Border tab, click on the None option in the Presets and so click on OK.

This will make the diagonal line go away.

Then this is how y'all can easily divide the cells diagonally in Excel by inserting a line using the format cells dialog box options.

I hope yous found this tutorial useful.

Other Excel tutorials you may also like:

How to Indent in Excel (3 Like shooting fish in a barrel Ways + Keyboard Shortcut)
How to Add Bullet Points in Excel
How to Split Cells in Excel (separate into multiple columns)
How to Freeze Row/Column Headers
Working with Gridlines in Excel: How to Add, Remove, Change, and Impress Gridlines
How to Rotate Text in Cells in Excel
How to Split Screen in Excel (Compare Side-by-Side)
How to Insert/Draw a Line in Excel (Straight Line, Arrows, Connectors)