The Format Painter takes the formatting from one piece of text or item and pastes it onto something else you select. This is handy when you have a combination of formats on something and want to apply them to another item, without having to do them individually.
To use it:
You can use the Format Painter. Click anywhere in the paragraph. Then click the Format Painter. The select the paragraph you want to paste formatting onto and it will do it.
Format PainterFormat painter
The Format Painter.
The Format Painter. You can also use Paste Special and choose just to paste the formatting.
Double Click the format painter
Double Click the format painter
Double Click the format painter
Yes, the Format Painter copies the format of the text (e.g. font style, size, bold, etc.) but not the actual text. To use the Format Painter, highlight the formatted text that you want to mock. Then click the Format Painter icon and highlight the text that you want to format like the previous text.
format painter
The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.The Format Painter or pasting formats through Paste Special after doing a copy.
The Format Painter.
Click on the cell that you want to take formatting from. If you click once on the Format Painter, you can then click on another cell and it will receive the formatting from the other cell and the Format Painter will be deactivated. If you double click on the Format Painter, then it is turned on until you click on it again, meaning you can apply formatting to lots of cells.