Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
WOSB (Women-Owned Small Business) Certified
For Microsoft Office 2003 and earlier versions
Microsoft Office programs offer a quick way to copy formatting from
one item--such as text in Word, a cell in Excel, a shape in PowerPoint,
or even a form control in Access--to another. The key is the Format
Painter and it might be the most helpful toolbar button you've never
How to Use the Format Painter
Whether you are using Word, Excel, PowerPoint, Access or even
Publisher, the Format Painter works the same basic way:
- First, select the "good stuff", that is, the text, cells, or
object that has the formatting you want to duplicate.
- Next, look on your Standard toolbar for a yellow paintbrush
- Finally, select or click and drag on the text, cells, or
objects that you want to take on the selected format.
If you want to apply the same formatting to more than one
item, select the formatting you want, and double-click the
Format Painter tool, and then select the item you want to apply
formatting to. You can continue to repeatedly apply formatting
and then press [Esc] to cancel.
Double-click on the Format Painter
toolbar button to "lock-in" the paintbrush icon and to repeat the
|The Format Painter
tool works in Microsoft Office programs including Word, Excel,
PowerPoint, Publisher, and Access.