Excel Tips For Noobs: How To Add Diagonal or Crossed Lines to a Cell
Iím guessing you found this article because you asked a search engine ďHow do you add diagonal or crossed lines to a cell?Ē Well, these diagonal lines that you want to add across a cell are defined as a type of border in Excel. But letís be honest, they are not borders. A case where you might use a diagonal line is on a work schedule. Suppose a certain worker canít work certain days. In this case you might use diagonal lines to remind yourself not to schedule that employee on those particular days. See below.
How to Add Diagonal Lines in Cells
Adding diagonal lines in a cell is simple. Follow the steps below and you wonít ever have to ask how to add diagonal lines in Excel ever again.
Step 1: Click on the arrow on the Border button which is on the ribbon under the Home tab. A drop-down menu will appear with different border options.
Step 2:From the Border drop-down menu select Draw Borders. Your cursor will turn into a pencil.
Step 3: Now draw a line from one corner of the cell to the opposite corner of the cell. If done correctly you will have drawn a diagonal line across your cell.