Using Format Painter

To use Format Painter:

1. Place the cursor anywhere in the text whose formats you want to copy.
2. Click the Format Painter button on the Formatting toolbar.
3. Notice that the cursor turns into a paintbrush.
4. Select the text you want to format.
5. When you deselect the text, you can see the new formatting.

Use Format Painter to quickly apply all the formats from one part of your workbook to another. Place the cursor anywhere in the cell you want to copy formatting from. Click the Format Painter button on the Formatting toolbar. Notice that the cursor turns into a paintbrush. Now select the text you want to apply the formatting to. When you deselect the text, you can see the new formatting.