Add Diagonal Border in MS Exel


Excel logo

Did you know that you can add diagonal borders to the cells in your Excel worksheet?  Well you can!  You can put border on the right, left, top, and bottom of your cells.

If you select a range of cells, you can even add those borders in between – the borders could be between cells within your selected range!

Follow the steps below to learn how:

  1. Select the cell in which you would like to have a diagonal border.
  2. Click on the Home tab of your Ribbon.
  3. In the Cells group, click Format tool | Format Cells, which will display the dialog box.
  4. Click on the Border tab is is is not already displayed.
  5. In the Preview area, at the bottom left and right corners of your dialog box you should see buttons that have diagonal lines on them.
  6. Click the line that is the diagonal border of your choice.
  7. Click OK.

Pretty cool huh?

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.