Format Painter is a utility given in Excel which is used to copy the format of one text to the other within a fraction of a second.
Format painter is very useful tool especially when we have gathered the content from various sources or reports.
It helps us to directly copy the Font of one content to the other directly.
Format is the size, color , font etc. properties of the text.
The button location of FORMAT PAINTER is present under Home Tab. The location is
HOME TAB>FORMAT PAINTER UNDER CLIPBOARD SECTION
In the above mentioned example, there are two texts, current format and intended format.
We select the intended format(The format which is desired) , click on format painter and click the current format (The current format). The current format changes to the intended format at once.
When we double click the format painter, the command doesn’t reset after a single use but keeps on changing the format of the text , wherever we click.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE