Use The Format Painter - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. 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 in the Clipboard group. 

   

3. The cursor changes to a 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.

   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?

DiscoverCommunity

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

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

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

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×