Use the Format Painter

Applies To
Excel 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 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

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 button Format Painter in the Clipboard group. 
    Format painter button on ribbon

  3. The cursor changes to a Shows format painter cursor with paintbrush paintbrush 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 button Format Painter.

    Tip

    Use Alt+Ctrl+C to copy a format, and Alt+Ctrl+V to 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.

Note

  • 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).