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 want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website 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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s