Diagonal lines in a cell in Excel

With a table of data in Excel, to save space people often divide a cell into 2 triangular cells diagonally from each other. The following article will guide you in detail how to diagonal lines in 1 cell (cell) in Excel to help you present your table quickly and beautifully.

To create a diagonal line that looks like a cell, simply right-click the cell you want to create a diagonal line -> select Format Cells:

Diagonal lines in a cell in Excel Picture 1

The dialog box appears select Border card -> click the diagonal icon as shown -> click OK to finish:

Diagonal lines in a cell in Excel Picture 2

Align text content in cells, resulting in diagonal lines in 1 cell in Excel:

Diagonal lines in a cell in Excel Picture 3

Alternatively, you can create your own diagonal lines in Excel by clicking Insert -> Illustrations -> Shapes -> selecting the line icon to draw the diagonal directly in the cell:

Diagonal lines in a cell in Excel Picture 4

The above is a detailed guide on how to diagonal lines in 1 cell in Excel. Hope to help you in the process of working.

Good luck!