Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Copying Formatting with the Format Painter

The Format Painter is like a mini-formatting copier that is available on the Standard toolbar (its tool looks like a paintbrush). To use the Format Painter, select the text you want to use as a model, click the Format Painter tool, and then click the target cell or range of cells to “paint” it with the same formatting. The mouse pointer changes to a paintbrush during this process.

The next To Do exercise demonstrates how to use the Format Painter tool to copy formats in the My Budget workbook.

To Do: Copy Formats with the Format Painter Tool

1.	Click the Summary sheet tab. Select cell B3.
2.	Click the Format Painter button on the Standard toolbar. You should see a copy marquee surrounding cell B3. The ...