Drawing Borders

The normal way to add borders around a cell or range of cells is to display the Format Cells dialog box and use the Border tab. There is also a quick shortcut you can use to actually "draw" borders around cells.

Display the Home tab of the ribbon. In the Font group, click the down-arrow at the right of the Border tool. Excel displays a whole range of options; you want to choose Draw Borders. Choose this, and the mouse pointer becomes a small pencil and the Borders toolbar appears.

Now you can just click and draw borders where ever you want them. You can click the down-arrow at the right of the Border tool, again, to select options to specify what type of line you want (Line Style) and what the line color should be (Line Color).

When you are done creating your borders, just click the Esc key. The mouse pointer returns to normal, and you can use Excel like you normally do.