If you click it once and then apply formatting, it will turn itself off automatically. If you double click it, it will turn it on and allow you to do multiple formatting, pasting formatting onto anything you click. If you click the Format Painter again, it will turn it off.
Format PainterFormat painter
The Format Painter.
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.
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.
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.
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.
The Format Painter.