Create diagonal line in cell

When you want to show to separate headings within a same cell (one for the row and one for the column), in that case you need to split a cell diagonally. Always remember that cell is a combination of row and column.

For Example :

Suppose you have data as per image shown below. Now suppose want to insert headings for both column and row in cell A3 for list of name and list of month.

STEPS :

1. Select cell A3.
2. Right click on it and Click on format cells…
3. In the format cell dialogue box, go on border tab.
4. Click on  diagonal line icon at the bottom right.
5. Click ok.

6. See the result in below image.

---

How to remove diagonal line in excel ?

STEPS :

1. Select the cell or cells from which you want to remove the diagonal line.
2. Right click on selection and choose “Format cell…”
3. Click on “Border” tab in format cell dialogue box.
4. Click “None” option and then click “OK”