Part I: Getting Started with Excel
FIGURE 5.10
Use the Border tab of the Format Cells dialog box for more control over cell borders.
Copying Formats by Painting
Perhaps the quickest way to copy the formats from one cell to another cell or range is to use the Format
Painter button (the button with the paintbrush image) of the Home ➪ Clipboard group.
- Select the cell or range that has the formatting attributes that you want to copy.
- Click the Format Painter button. The mouse pointer changes to include a paintbrush.
- Select the cells to which you want to apply the formats.
- Release the mouse button, and Excel applies the same set of formatting options that
were in the original range.
If you double-click the Format Painter button, you can paint multiple areas of the worksheet with the
same formats. Excel applies the formats that you copy to each cell or range that you select. To get out
of Paint mode, click the Format Painter button again (or press Esc).
