Use the Format Painter
on the Home ribbon to copy the text format from one of the other buttons: With one of the existing buttons selected, click first on the Format Painter
icon, then on the new button.
Marsha Troy, a CPA from Shawnee, Kan., suggests a third way--with Format Painter
The new Format Painter
copies the color, line weight and style, font and other attributes and applies them with one click to other objects.
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.
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.
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.
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?
If you have developed a conditional format that you want to use in other cells, you can easily copy it using the Format Painter
Germany, a CPA who works for the Department of Defense and has a small private practice, suggested an even simpler way: Double-click (rather than single-click) the Format Painter
in the toolbar.
The Format Painter in the toolbar is helpful, but after a while it, too, gets to feel a bit clunky.
Before I suggest a shortcut, let's review the use of the Format Painter. To copy a format from one part of a document to another (it works in both Excel and Word, by the way), highlight the cell or cells that have the format you want to copy, click on the Format Painter and then, with the cursor, swipe the text you want formatted.
Quattro Pro lacks the handy format painter
function contained in both Excel and Lotus.