Expand The Use Of Format Painter In Word

BY STANLEY ZAROWIN

Q. Format Painter is a very handy tool for copying a format style from one place to another, but it seems to work with only one section at a time. Is there a way to get it to work like a rubber stamp in as many different places as I wish?

A. Yes, there is, but before I show you, I want readers to understand how to use Format Painter , which is in your Word and Excel toolbar and looks like a paintbrush.

Let’s say you have a word (or a sentence or paragraph or spreadsheet cell) whose format you’d like to replicate in another part of your document or worksheet. Begin by highlighting the source word (or whatever it is) and then click on Format Painter . As you move your cursor, it instantly will change to a small paintbrush. Wipe it across the words or cells to which you want the new formatting to apply and click again. That’s it: The target text or cell will have the new formatting.

Now to answer your question—how can you use the Format Painter on multiple sections of your document or spreadsheet without going back each time to copy the format source? After you highlight the formatted characters you want to copy, double-click on the Format Painter and paint the formatting style anywhere you want. The cursor-turned-paintbrush will remain as long as you wish. To turn it off, press Esc or click again on the Format Painter icon.

If Format Painter is not in your toolbar, click on Tools , Customize , the Commands tab and then Format. Cursor down the list and when you find the paintbrush icon just drag it up to your toolbar.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.