Borderline Command in Excel 2010 part 2

Selecting Draw Border Grid also calls up that pencil (duly sharpened) to the screen, and lets you draw lines around all the borders  of any range of cells. And if you want, you can drag the pencil down only one column border, or only the lower border of  cells. Thus, you can use Draw Border Grid to produce a border like this (Figure 4–18):

Erase Border will, when clicked, restyle the mouse pointer into an eraser. Once it’s in view, you can click the eraser on any  particular border line and the line will disappear. You can click on individual border lines or drag over a series of borders;  either way, when the mouse is released the lines vanish.

Again, to turn the eraser off, press Esc (Figure 4–19):

Line Color is really a subtle variation on Draw Border Grid. Click the command, select your color (Figure 4–20):

There’s that pencil again (Figure 4–21):

Then, as with Draw Border Grid, drag the pencil over the desired cells. A border appears around all sides of the selected cells,  in the desired color. You can apply this command to borders that currently don’t display a line, or to existing, standard-black  border lines, which means you can re-color borders.

Line Style allows you to modify the texture and weight (thickness) of the lines you draw (Figure 4–22):

so that your borders can take on a different look, e.g., see Figure 4–23:

The final line option, More Borders, is, alas, the most confusing. It too allows you to draw lines around selected borders of  selected cells, including diagonals running through cells. But you need to pay close attention to what the dialog box is trying to  tell you. If you select just one cell on the worksheet, you’ll be brought to the More Borders tab in the Format Cells dialog box,  which looks like Figure 4–24 (note that here it’s just titled “Border”):