Microsoft Office Tutorials and References
In Depth Information
Decorating a Worksheet with Borders and Colors
Slapping borders on worksheet cells
Put borders on worksheet cells to box in cells, draw lines beneath cells, or
draw lines along the side of cells. Borders can direct people who review
your worksheet to its important parts. Typically, for example, a line appears
above the Totals row of a worksheet to separate the Totals row from the
rows above and help readers locate cumulative totals.
To draw borders on a worksheet, start by selecting the cells around which
or through which you want to place borders. Then do one of the following to
draw the borders:
✦ Borders button: On the Home tab, open the drop-down list on the
Borders button (it’s in the Font group) and choose a border, as shown
in Figure 4-6.
✦ Drawing: On the Home tab, open the drop-down list on the Borders
button and choose Draw Border or Draw Border Grid. Then drag on the
screen to draw the borders. Press Esc when you finish drawing.
✦ Format Cells dialog box: On the Home tab, click the Format button and
choose Format Cells, or choose More Borders on the Borders button
drop-down list. The Format Cells dialog box opens, as shown in Figure
4-7. On the Border tab, select a border style and either click in the
Border box to tell Excel where to draw the border or click a Presets
button. The Border tab offers different lines for borders and colors for
borderlines as well.