What Is format Painter?

This is a function in Microsoft Office 365 that many don’t understand about. It’s very useful however underutilized. So, what does style Painter do? we’ll tell friend here, and once we do, you’ll uncover it as useful as us do.

You are watching: Describe the function of format painter


When have to You Use style Painter?

Whenever you want to use the very same formatting you produced in one record and apply it to another. As soon as I say formatting, I mean things like the color, font type, font size, and border style. Think that this a copying and also pasting but for your format types.

How perform You Use style Painter?

The other day I created an eBook around Office 365 come share v my staff. There room so many great features that I want them come take benefit of. The eBook to be pretty long so I developed a Table of contents they can refer to.

The layout was simple, but I wanted to make a few changes to make it simpler to read. Ns bolded the thing Heading to make it stand out.


To save a uniformed style throughout the Table that Contents, I required to execute the same with the various other chapter headings. Instead of going v the TOC and doing this one by one, ns used format Painter.

Here’s how:

I highlighted the copy I want to use. (Chapter 1)

Next, in the Home tab, ns clicked ~ above the format Painter option.

Next, ns highlighted the following Chapter Heading that I want to style (Chapter 2).

You’ll notice here that my cursor turned right into a paintbrush. This is the layout Painter paintbrush.


I take it the paintbrush and brushed end the chapter 2 line. Once I did the thing Heading style readjusted to what i had collection for Chapter

1. It automatically readjusted the format and not the text.

Once i did this, the Format artist turned off. But I want to copy the section Headings format throughout mine Table of Contents.

How do You Get layout Painter To remain On?

Here’s what i did:

After copying the subject header layout that I wanted to reproduce, ns double-clicked on the topic Headers that I want to apply the formatting to. I continued highlighting the topic Headers throughout the Table of Contents and double-clicked them.

This preserved the format Painter on. (Another means to store the layout Painter ~ above is to click the format Painter switch on the toolbar. But, this is much more cumbersome and also time-consuming than double-clicking.)



After i was perfect formatting the Sections, i turned off layout Painter by pressing ESC. The paintbrush disappeared telling me that i was no longer using style Painter. Quite cool, right?

Did You recognize That You have the right to Use style Painter In various other Office 365 Microsoft Applications?

I was functioning in word above. As with I duplicated formats over in Word for Microsoft Office 365, I can use it various other applications prefer Excel, PowerPoint, Pages, Keynote, Pages, Publisher, Gmail and more.

Just choose I walk above:

Choose the text, picture, shape or Excel cabinet that has the formatting you want to copy over.Go come Home and click on Format Painter. The cursor will change to a paintbrush.Click and also drag the paintbrush over the ar you desire to format.Release the mouse button, and the formatting will be changed.

How carry out You remove Formatting?

If you decision you no longer want the brand-new formatting, you deserve to remove it. Use the Clear Formatting function in your toolbar. Click to rotate it on and select the copy you want to change. The formatting will currently be went back to the original layout you created.

What If You desire To Clear every The Formatting native A Document?

Select all the text in the document.If you using Word go to the Edit Menu. Click Clear and then Clear Formatting.To carry out this in PowerPoint, go to the Home tab, and in the Font, Group click Clear every Formatting.

See more: Will An Egg Float In Sugar Water ? The Floating Egg

In Excel, walk to the Home tab, and from the Editing group, click the Arrow alongside the Clear button. Next, click Clear Formats to go back to the default layout for the selected cells.

With layout Painter and a tiny practice, you have the right to save so much time and frustration when copying styles and also formatting. Offer it a shot and you will do it soon get the cave of it!

Do you have questions about Format Painter?

Or maybe you have actually questions around other devices in Microsoft Office 365?