O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required