Diagonal lines in a cell in Excel

Instructions on how to diagonal lines in a cell (Excel) help you present the table quickly and beautifully. To create diagonal lines, just right-click the cell you want to create a diagonal - select Format Cells: The dialog box appears, select the Border tab - click the icon.

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:

Picture 1 of Diagonal lines in a cell in Excel

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

Picture 2 of Diagonal lines in a cell in Excel

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

Picture 3 of Diagonal lines in a cell in Excel

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:

Picture 4 of Diagonal lines in a cell in Excel

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!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile