Copy and apply text formatting using the Format Painter in Word,
Excel and PowerPoint
Located in the Standard toolbar, the Format Painter tool icon (looks like a paint brush) is used to copy the format of a selected object or text to other objects or text.
Located in the Standard toolbar, the Format Painter tool icon (looks like a paint brush) is used to copy the format of a selected object or text to other objects or text.
In Word, for example, if you have text formatted in 10 pt, Arial, black, you can easily transfer this text formatting to any other text in the document with Format Painter.
1) Select the text that has the formatting that you want to copy and transfer.
2) Click the Format Painter icon. It becomes indented which verifies you've selected it.
3) With your cursor, which now has a paintbrush attached to it, select the target text you want to format.
4) The target text immediately changes to match the format of the original text. As soon as you select the target text, the Format Painter icon becomes inactive.
Note: To make the Format Painter icon remain active so that you can continue formatting text, repeat steps 1 - 3, except this time in step 2, double-click the icon. When you are done formatting you must click the icon again to deactivate it; otherwise you will continue reformatting any text you select.