Applies ToExcel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 OneNote for Microsoft 365 Project Online Desktop Client Publisher for Microsoft 365 Visio Plan 2 Excel 2024 Word 2024 PowerPoint 2024 Access 2024 OneNote 2024 Project Professional 2024 Project Standard 2024 Visio Professional 2024 Visio Standard 2024 Excel 2021 Word 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 OneNote 2021 Excel 2019 Word 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Project Standard 2019 Publisher 2019 Visio Professional 2019 Visio Standard 2019 Excel 2016 Word 2016 PowerPoint 2016 Access 2016 OneNote 2016 Project Professional 2016 Project Standard 2016 Publisher 2016 Visio Professional 2016 Visio Standard 2016 InfoPath 2013 InfoPath Filler 2013 Project for Office 365

Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one—think of it as copying and pasting for formatting.

  1. Select the text or graphic that has the formatting that you want to copy.

  2. On the Home tab, select  Format Painter buttonFormat Painter in the Clipboard group. 

    Format painter button on ribbon

  3. The cursor changes to a Shows format painter cursor with paintbrushpaintbrush icon.

  4. Use the brush to paint over a selection of text or graphics to apply the formatting. This only works once. To change the format of multiple selections in your document, you must first double-click Format Painter buttonFormat Painter.

    Tip: Use Alt+Ctrl+C to copy a format, and Alt+Ctrl+Vto paste a format. While the cursor does not change to a paintbrush, you can repeatedly select text and paste formatting to multiple areas without re-copying. 

  5. To stop formatting, press ESC.

Notes: 

  • If you want to copy text formatting, select a portion of a paragraph. If you want to copy text and paragraph formatting, select an entire paragraph, including the paragraph mark.

  • For graphics, Format Painter works best with drawing objects, such as AutoShapes. However, you can copy formatting from a picture (such as the picture's border).

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.