Microsoft Office Tutorials and References
In Depth Information
A New Kind of Copy—and Paste
the formatting of a source cell, and leave the cell’s data behind. You may be so taken by the appearance
of a cell that you decide you want—or need—other cells to take on that same appearance. And if that’s
what you need to do—copy a set of formats in one cell to other cells—there’s a handy way in which to
do so.
But that very objective raises a question. Why bother to copy a format from one cell to another
when I can simply click on the new cells and select any and all of the formatting options we’ve
discussed so far? Why not format these new cells directly , without copying the formatting from
somewhere else?
Good question; and the answer is that you may want to copy formats from a cell that contains
numerous formatting changes, and you can’t be bothered to reintroduce all of them to additional cells
se r i a l l y . For e xa mpl e —suppose ce l l B6 con ta i n s a n 1 8- poi n t, Book ma n Ol d Sty l e fon t, col or e d g r e e n
and underlined, with a Center alignment to boot. If, for reasons best known to me, I admire this
pastiche of cell adornments and want to impose them on other cells, it may be too much trouble to
implement each adornment separately. But with a tool called the Format Painter I ca n copy all of B6’ s
formatting features to other cells in one shot.
And to see how Format Painter works, we can swing back to the Home tab’s Clipboard Group, a
venue we visited a few chapters earlier when we introduced the Copy and Paste buttons (Figure 4–86):
Figure 4–86. Where to find the format painter
To use Format Painter:
Click the cell whose formatting you wish to copy. Then click the Format Painter button,
after which you’ll see (Figure 4–87):
Figure 4 87. Giving your cells the brushoff: The Format Painter in action
Search JabSto ::

Custom Search