It enables you to copy the format you have used in one or more cells, and apply it to other cells. A cell using a combination of formatting can have all of its formatting applied to other cells, without having to apply the individual settings one at a time.
It allows you to "paint the format of one section of text to another section. For example, If you were creating a newsletter that had multiple headlines, you could use the format painter to copy the font type, size, color, etc from the first to the next headline
To quickly copy formatting from one thing to another. It can be used in different applications and for many kinds of things, like text to other text in Word, or formatting from one cell to another cell in Excel etc.
single click the format button
(Home Tab-Clipboard)
Double click on the Format Painter icon and it will stay on until you click on it again to turn it off.
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
It displays several options about what you can paste, like everything, format only, formulas only, special format, etc.
In the Clipboard group, click the Format Painter button once to turn of the command off, Alternatively, press the ESC button on you keyboard to turn off. Source: Go!Office 2007
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 button that you can use to apply multiple formatting style to selected cell is called format painter (the icon is a little brush on the "standard" toolbar). The way it works is as follows: 1/ select an area of the spreadsheet that already have the formatting that you want to use. 2/ click on the format painter button on the standard toolbar. 3/ select the area of the spreadsheet where you want to copy the formatting. That's all. Note that if you want to apply the same formatting in several places, you can double click on the format painter button in step 2/ instead of a single click. Then you can do step 3/ several times. When you are finished, click again on the format painter button to deactivate it.
It is in the Clipboard group.
Yes. The Format Painter can take the formatting from one thing and paste it onto another.
No. It looks like a paint brush.
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.