Do you want to format an object or text with the same format as the old one but want to save time instead of formatting the new object? You can use format paint in Word, PowerPoint and Excel.
Format Painter is a Microsoft Office feature that allows users to apply the same formatting, such as font style, size, color, and border styles, to multiple texts or objects. It works well with graphics, like AutoShapes. You can also copy the formatting of an image, such as the border of the image.
How to Use Format Painter in Word and PowerPoint
- Launch Microsoft Word either PowerPoint.
- Enter a text or object in your Word document and format it.
- Enter another text or object and keep it simple.
- Highlight the text or object.
- About him Home tab, click the format paint button on the Clipboard cluster.
- You will see a mini brush along with a cursor; drag the brush over the plain text or object.
- It will be converted to the same format as above.
If you want to apply formatting to multiple texts or objects, double click he format paint button.
How to use Format Painter in Excel
- Launch MS Excel.
- Enter a text or object in your Word document and format it.
- As you have seen in the photo above, there are two texts in the spreadsheet with different formats. We want to convert the text at the bottom to the format of the text at the top.
- Click the text cell at the top of the spreadsheet.
- About him Home tab, then click the format paint button on the Clipboard cluster.
- You will see a mini brush along with a cursor; drag the brush over the text at the bottom.
It will be converted to the same format as the text at the top.
We hope you understand how to use the Format Painter in Word, PowerPoint, and Excel.
What is the shortcut for Format Painter in PowerPoint?
Microsoft PowerPoint users can use the Format Painter hotkeys to copy and paste formatting. Follow the steps below.
- Select the object or text, then press the Ctrl + Shift + C keys.
- To paste the format, click the object or text placeholder and press Ctrl + Shift + V.
READ: How to fit a large image on a PowerPoint slide
How do I copy the format 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 the cell that contains the formatting text, then right-click the cell and select copy from the context menu.
- Open PowerPoint, right-click inside the text box, and select Preserve Source Formatting under Paste Options.
READ: How to Find and Replace Text Color in Excel.
