Using Format Painter
When creating your workbook, you will probably want similar headers to have the same formatting. Use Format Painter when you want to quickly apply the text formatting from one part of your workbook to another part.
To use Format Painter:
- Place the cursor anywhere in the text whose formats you want to copy.
- Click the Format Painter button on the Formatting toolbar (the cursor becomes a paint brush).
- Select the text you want to format.
If you want to apply the formats more than once, double-click the
Format Painter button when you select it. It will stay on until you click it again or press
to deselect it.