How to Draw a Diagonal Line Through a Cell in Excel

  • MORE

Admittedly, there aren’t many cases where you’ll need to, but if you should ever need to draw a line, diagonally, through a spreadsheet, it’s actually quite easy. I found myself with this problem recently -- needing to draw a diagonal line in a workbook -- and was quite perplexed on how to do it. After some Googling, I found the answer, and today I’ll share it with you.

hero copy

In my example, I needed to add a dividing line in the top left cell separated Name and Sales in a way that made it clear Names went in Column A and Ages were part of Row 1. We’ll repeat that for this example.

1. Open a Blank workbook in Excel

blank

2. You can do this in any size of cell, but it’s easier to understand if you make it larger first. To do that, we’ll just click and hold the line between Row 1 and 2, and then drag until it’s at the desired height. Then do the same for the column to expand it horizontally

drag copy

 

3. Right click the cell and select Format Cells

format

4. At the top, click the Border tab

border

5. And then choose the diagonal line option at the bottom right of the menu. You can choose to draw your line in the opposite orientation by clicking the other diagonal line icon on the lower left of the menu.

diagonal

6. Click OK.

ok

7. Now type the text you want at the top of your diagonal line and press Alt + Enter to move to a new line. 

text

8. Type the text on the bottom, and then press enter. 

bottom

9. If the formatting is off, just double click within the cell and use the spacebar to move the top text over.

space

 

 

Add a comment