How to Draw Borders in your Excel Worksheet


Usually one would add borders around a cell or range of cells in their worksheet by selecting the cell or range and using the Border tab of the Format Cells dialog box.

BUT, there is a nice little shortcut that saves you time and keystrokes and who wouldn’t want to do that??

Follow the steps below to learn how:

  1. First, display the Home tab or your Ribbon.
  2. In the Font group, click the down arrow at the right-hand side of the Border tool to display options.

Draw-Border

  1. Select Draw Borders and you will notice that your cursor has not become a small pencil.

Pencil-cursor

  1. You can now click and draw borders wherever you like.
  2. You can utilize the options by clicking the drop-down arrow on the right hand side of the Border tool to specify the type of line and color.
  3. Once you are finished creating borders, you can simply click the Esc key and your cursor will again return to normal.

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.

There are no comments

Your email address will not be published. Required fields are marked *