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.

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

  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?


Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!