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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.