How to Insert Diagonal Line in Excel | Split Cells Diagonally

Показать описание

Here's how to insert diagonal line in excel to split cells diagonally to make 2 headers in one cell:

1. Select the cell.
2. Enter the first header then use shortcut ALT+ENTER and enter the second header.
3. Right click the cell and select "Format Cells". It'll open a new dialog box.
4. Select "Border" tab and then select the "Diagonal" option (left to right or right to left). Click ok.
5. Now you can see the diagonal in excel. Add spaces in the cell and resize it so that it looks visually good.

Done! You have added a diagonal in excel in just 4 easy steps.

If you want to learn more excel concepts like pivot tables, dashboards, vlookup, IF formulas, conditional formatting, macros etc. Then checkout our advanced Excel course with over 10+ hours of content, 50+ exercises, doubt support and much more.

🚩Follow us on:

#excel #exceltips #exceltutorial #microsoftexcel #tutorial #microsoftoffice #googlesheets #exceltricks