Section 10 - Format Painter

Use the Format Painter to copy the formatting from one cell to other cells. This feature prevents you from having to apply formats to each cell or range individually. For example, you can apply font type, style, size and color as well as number formatting all at one time.

• To use the format painter, select the cell with the formatting you wish to copy.
• In Excel XP or MAC Excel 2004, click on the Format Painter button from the Standard Toolbar. The blinking marquee outline appears aroun d t he selected cells.
• In Excel 2007, under the Home tab click on the Format Painter button in the clipboard group.
• The mouse pointer changes from an arrow to one with a paintbrush attached to it.

• Select the cell(s) you wish to copy the formatting to and notice the cells change to the selected formatting.