answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you activate the format painter button?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

To turn the format painter off you must?

single click the format button


What is the path to the format painter button?

(Home Tab-Clipboard)


How do you turn the format painter off?

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


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.


The Format Painter button is found in the group on the HOME tab of the Ribbon?

It is in the Clipboard group.


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 use the Format Painter on multiple items?

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.


Does the format painter button copies both the cell's content and formatting?

No. It only copies the formatting. It does not copy content.


Which feature allows you to copy multiple format settings at once?

Format PainterFormat painter


How many times do you click the format painter button and then drag through the nonadjacent ranges to paint the formats to the ranges?

Double Click


What is a feature that applies the formats associated with a selection to another selection?

The Format Painter.