| |
Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
(303) 699-6868
Dawn@SoftwarePro.com
|
| | For Microsoft Office 2003 and earlier versionsMicrosoft 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 used. How to Use the Format PainterWhether 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 tool.
- Finally, select or click and drag on the text, cells, or objects that you want to take on the selected format.
Bonus TipIf 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 format copy.
|
| The Format Painter tool works in Microsoft Office programs including Word, Excel, PowerPoint, Publisher, and Access. |
|
Tips, Tricks, Secrets
that you need to know now!
|
|
