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.
Click the Summary sheet tab. Select cell B3.
Click the Format Painter button on the Standard toolbar. You should see a copy marquee surrounding cell B3. The ...