Question

What is Format Painter? When do you think Format Painter is useful in Excel?

Answer 1

Answer:

The format painter lets you copy all of the formatting from one object and apply it to another one – think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy. If you want to copy text formatting, select a portion of a paragraph.