Windows  |  Free Downloads




Format Painter in Microsoft Office

The Format Painter is a very cool tool. It'll copy the format from one "thing" to another. It's located right up on your standard toolbar in Word, Excel, PowerPoint, FrontPage, and Access.

The picture below shows the location of Word's Format Painter if you've followed our Recommended Menu Settings article for Word's toolbars.

You have a perfectly formatted paragraph, and you can't seem to get another one to be formatted the same way. To use the Format Painter:

  1. Select the perfectly formatted paragraph.
  2. Click on the Format Painter toolbar button.
  3. Click anywhere in the middle of the next area of text that you want formatted perfectly.

You can turn the Format Painter on and leave it on until you turn it off.

  • Double-click the Format Painter button to turn it on.
  • Single-click to turn it off. debuted on May 26, 2005. provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy