How to use Format Painter in Word, Excel, PowerPoint

Would you like to format an object or textual content with the identical formatting because the earlier one however need to save time than formatting the brand new object? You may use Format Painter in Phrase, PowerPoint, and Excel.

The Format Painter is a characteristic in Microsoft Workplace that enables customers to apply the identical formatting, resembling font fashion, dimension, shade, and border types, to a number of textual content or objects. It really works nicely with graphics, resembling AutoShapes. You may also copy formatting from an image, such because the border of the image.

How to use the Format Painter in Phrase and PowerPoint

1. Launch Microsoft Phrase or PowerPoint.
2. Enter a textual content or object in your phrase doc and format it.
3. Enter one other textual content or object and make it plain.
4. Spotlight the textual content or object.
5. On the House tab, click on the Format Painter button in the Clipboard group.
6. You will notice a mini brush together with a cursor; drag the comb on the plain textual content or object.
7. It will likely be transformed to the identical formatting because the earlier one.

In order for you to apply the formatting to a number of textual content or objects, double-click the Format Painter button.

How to use the Format Painter in Excel

1. Launch Microsoft Excel.
2. Enter a textual content or object in your phrase doc and format it.
3. As you will have seen in the picture above, there are two texts in the spreadsheet with totally different formatting. We would like to convert the textual content on the backside to the formatting of the textual content on the prime.
4. Click on the cell of the textual content on the prime of the spreadsheet.
5. On the House tab, then click on the Format Painter button in the Clipboard group.
6. You will notice a mini brush together with a cursor; drag the comb on the textual content on the backside.

It will likely be transformed to the identical formatting because the textual content on the highest.

We hope you perceive how to use the Format Painter characteristic in Phrase, PowerPoint, and Excel.

What is the shortcut for Format Painter in PowerPoint?

Microsoft PowerPoint users can use the Shortcut keys of the Format Painter to copy and paste formatting. Follow the steps below.

• Select the object or text, then press the Ctrl + Shift + C keys.
• To paste the formatting click on the placeholder of the object or text and press the Ctrl + Shift + V keys.

READ: How to fit a large Picture into a PowerPoint slide

How do I copy formatting from Excel to PowerPoint?

If you want to copy a text or object from Excel and want to keep the formatting when pasting it into PowerPoint. Follow the steps below:

• Click on on the cell that incorporates the formatting textual content, then right-click the cell and choose copy from the context menu.
• Open PowerPoint, right-click contained in the textual content field, then choose Preserve supply formatting beneath Paste Choices.

READ: How to Discover and Exchange Textual content Colour in Excel.