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 A TOOL IN MICROSOFT EXCEL TO COPY THE FORMAT OF ONE TEXT AND PASTE IT ON THE OTHER AT A LIGHTENING SPEED.
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, the one which is already there) , 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.
Shortcuts always save us a lot of time if we know them.
There are many shortcuts in Excel but we need not to remember all of them.
Always shift to the shortcuts for your repetitive jobs.
The shortcut key for the FORMAT PAINTER is ALT+H+F+P.
Keep ALT pressed followed by pressing H,F AND P letters.
The format painter will be selected.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE