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
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:
- Select the perfectly formatted paragraph.
- Click on the Format Painter toolbar button.
- Click anywhere in the middle of the next area of text that you want
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.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com 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