Borders

Excel offers many border styles that you can apply to separate cells or a selection of cells (Figure 38).

Figure 38. Use borders to place lines under headings and above and below column totals.

Use the Formatting Palette or the Format Cells dialog to add and format borders.

To add borders with the Formatting Palette

1.
Select the cell(s) to which you want to add borders.
2.
Choose the type of border you want to apply from the Border Type pop-up menu in the Borders and Shading area of the Formatting Palette (Figure 39).
Figure 39. The Border Type pop-up menu on the Formatting Palette.
3.
To change the style of the border, choose a style from ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.