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!
You should read it
- Instructions on how to create diagonal lines in Excel box
- How to create a diagonal line in a table cell in Word?
- How to create diagonal lines in Word tables?
- Write italic, vertical, and diagonal lines in Excel
- How to indent the line in Excel
- Excel with hidden lines - How to hide lines and display hidden lines in Excel
- Some experience in Excel spreadsheets
- Instructions to delete blank lines (blank lines) in Excel
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Spacing lines in Excel
- 4 basic steps to color alternating lines in Microsoft Excel
- Instructions for deleting empty lines and columns in Excel 2016