Copying Formatting with the Format Painter

The Format Painter is like a miniformatting 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.