Double Click
In many word processing applications, the "Format Painter" button can be used to copy and paste paragraph formats. This tool allows users to select a formatted paragraph, click the Format Painter, and then apply the same formatting to another paragraph. Typically, the Format Painter icon looks like a paintbrush. Users can double-click the Format Painter to apply the formatting to multiple paragraphs consecutively.
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.
(Home Tab-Clipboard)
Yes, if you double-click the Format Painter button in applications like Microsoft Word or Excel, it becomes activated for multiple uses. This allows you to apply the same formatting to multiple items without having to click the Format Painter each time. To deactivate it, simply press the "Esc" key or click the Format Painter button again.
To copy the format of a cell in Excel without copying the contents, you can use the "Format Painter" tool. Select the cell with the desired format, click on the "Format Painter" button in the toolbar, and then click on the cell where you want to apply the format. This will copy the formatting without changing the contents of the cell.
In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.
single click the format button
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
If you double click the Format Painter button on the Standard Toolbar, you can apply the painter to multiple items until you click the button again to turn it off. Of course, if the items you want to apply it to are adjacent, you don't have to double click. Just drag the mouse across the items. When you release the mouse button, the painter is off, as usual.
It is in the Clipboard group.
No. It looks like a paint brush.
Yes. The Format Painter can take the formatting from one thing and paste it onto another.