Excel 2010 Bible

Part I: Getting Started with Excel

128

Adding Borders and Lines .................................................................................................

Borders (and lines within the borders) are another visual enhancement that you can add around

groups of cells. Borders are often used to group a range of similar cells or to delineate rows or col-

umns. Excel offers 13 preset styles of borders, as you can see in the Home ➪ Font ➪ Borders drop-

down list shown in Figure 6.9. This control works with the selected cell or range and enables you

to specify which, if any, border style to use for each border of the selection.

FIGURE 6.9

Use the Borders drop-down list to add lines around worksheet cells.

You may prefer to draw borders rather than select a preset border style. To do so, use the Draw

Border or Draw Border Grid command from the Home ➪ Font ➪ Borders drop-down list. Selecting

either command lets you create borders by dragging your mouse. Use the Line Color or Line Style

commands to change the color or style. When you’re finished drawing borders, press Esc to cancel

the border-drawing mode.