0
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.
Wiki User
∙ 11y ago
Wiki User
∙ 11y agoIf you double click it, it will stay on until you turn it off again by clicking it once.
Add your answer:
Earn +20 pts
What is the effect of double clicking on the Format Painter icon?
If you click format painter for once you can use it at once ( in one particular cell or an array selected at once) If you double click the format painter, you can use it multiple times/selection - in multiple cells and multiple arrays. Please note that - to switch off the option activated by double clicking, you will have to press 'Esc'.
Which one of the following copies multiple formats from selected cells to the other cells?
You would use the format painter to copy formatting from one cell to another cell or cells. You can also use copy and then use Paste Special to copy just the formatting.Use the copy command and then paste format.
What function is used to copy a paragraph format to another paragraph?
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.
Which Office tool allows you to copy formatting from one area of your document to others?
The Format Painter. You can also use Paste Special and choose just to paste the formatting.
Does the format painter command copies text but not the format of the text?
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.
How do you copy formatting of a cell in Excel?
ctrl-1 will copy the format of the selected cell then you will have to select the cell in which you want to change. On the menu bar there is a icon that looks like a paint brush. You can select this icon to copy a cells format as well but you will have to still select the cell in which you want the change to happen.
What button copies multiple formats from selected cells to other 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.
How do you use Format Painter?
You use Format Painter by first adding your options to the open cell. Then, double click that cell to make it primary. This allows you to copy formats into non-formatted cells.
In Excel what do you do if you want to use the Format Painter more than once?
Double click on the Format Painter icon and it will stay on until you click on it again to turn it off.
The best tool to use to copy bold and Times New Roman 12pt is it format painter button?
Yes. The Format Painter can take the formatting from one thing and paste it onto another.
When you use the Format Painter button does the mouse appear as a paint can?
No. It looks like a paint brush.
How do you fill a destination aarea using the format of the source area no content is copied?
You can use the Format Painter to do it or the Fill formatting Only option.
