Whenever I conduct a training course in any of the Microsoft products, I always touch on the Clipboard group of tools. These include the Cut, Copy and Paste functions and almost all users have some type of experience using these tools. What many users have not utilised is the fourth little icon in this group called Format Painter.
Format Painter is a quick and easy way to copy the formatting from one location to another. I use this on a very regular basis and it replaces the need to format different pieces of text multiple times. I am often asked “why don’t you just create a style?” and whilst that is certainly an option, you may not want a style created for every single set of formatting which can be contained within a document.
The format painter will copy the font style, size, font colour, and other characteristics of the text you select but will not copy the actual text so if you like the look/feel of some text in a document, you can easily replicate it using this function. This feature comes in very handy where a document has been created by another user; instead of going through and working out how they have achieved a certain look, just use Format Painter to copy it within the same document or even across to a new document.
In this example I use Format Painter within Microsoft Word, however the process is the same in Excel and PowerPoint. You can even use Format Painter when creating email messages in Outlook.
To use Format Painter, follow these steps:
- Open Microsoft Word
- Create the sample headings below:
Things to see
- Apply formatting to the first heading (Destination) including font style, size, colour, bold, underline and centre the text on the page
- Now apply a second set of formatting to the second heading (Travel) however use different properties and make the text right aligned
- Now we will copy the formatting from the first two headings and apply them to the remaining headings
- Highlight the first heading (Destination)
- Click the Format Painter icon from the Home tab
- You will notice your mouse cursor will now have a paint brush icon next to it and the Format Painter button has turned orange on the ribbon. The button turning orange identifies that the function is active.
- Be careful where you click next on your document, this is not the best time to get “trigger happy” with the mouse! Wherever you click next will determine where the formatting you’ve just copied will be applied to
- Highlight the third heading (Accommodation) and release the mouse button
- The heading will now be formatted the same as the first heading and the button on the Ribbon will return to it’s original colour to show the function is no longer active
- Repeat this process and copy the formatting from heading 2 (Travel) to heading 4 (Things to see)
- Repeat the process again to format the final heading in whichever style you prefer
- Now let’s take this feature to the next level…
- You can “lock” the format painter feature on so that you can continue to apply the same formatting to more than one heading/sentence/paragraph at a time
- Use the Undo (Ctrl + Z) feature to undo the formatting of the headings except for where you have formatted heading 1
- Now select the first heading and click the Format Painter button however use a double click this time
- The Format Painter button is again orange however it will remain orange even after you have applied the formatting to the first piece of text. The feature is now “locked” on so you can continually apply the chosen formatting to multiple locations within the document
- Format all five headings, one at a time, until all are formatted the same
- To turn off the Format Painter feature either press Esc on the keyboard or click the Format Painter button once more to turn it off
- The button should return to its normal grey colour
Congratulations you have now used the Format Painter function to apply formatting to your document. If you have any questions do not hesitate to contact me.