The Format Painter

By far, the format painter format painter is one of my favorite tools in Microsoft Office. It is very easy to learn. But before I explain the steps to making it work, let me define what it does. The format painter will copy the format from one part of your document to another place. For example, it could help you quickly copy a sub heading format in a Word document to other sub headings in the document. In Excel, it could copy how a particular cell range looks onto another cell range (even using multiple worksheets at a time). So the format painter looks like a tiny little paint brush.

format painter

To make it work, first select some text to you would like to copy-cat the format to other locations in the document. Then click the format painter which is in the clipboard group of the home tab (Office 2007 or 2010). Upon clicking the format painter button, your mouse icon will display a paint brush. Drag or click onto the text you would like to copy the formats to.

TIP: If you have a lot of formatting to do, double click the format painter so that you can use it as long as you need. Make sure when you are finished with its use, that you eithor click the format painter button or hit ESC to turn it off.

About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel, PowerPoint, Word and tagged , , , . Bookmark the permalink.

3 Responses to The Format Painter

  1. Pingback: How to format dates that are over 1 year old to turn red in Excel using conditional formatting. | Steve Chase Docs

  2. Nigel says:

    “The Format Painter | Steve Chase Docs” was
    in fact a great post and thus I actually was in fact pretty
    joyful to discover the blog. Regards,Cristina

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s