Microsoft Office Tutorials and References
In Depth Information
A New Kind of Copy—and Paste
Bewildered? Quite a variety of Paste options indeed. But here we want to examine only those
Paste buttons that carry out various formatting actions.
These two buttons (Figure 4–89):
Figure 4–89. Two Paste options: Formulas & Number Formatting, and Keep Source Formatting
are called Formulas & Number Formatting , an d Keep Source Formatting , r e spe cti v e l y . T he fi r st
button copies only a cell’s formula (there has to be one in the cell, needless to say) and its number
formatting. The button won’t copy a n y othe r k i n d of for ma tti n g , e tc., fr om the sour ce ce l l . But the
second button, Keep Source Formatting, does bring over all the formatting from the source cell, along
with that cell’s contents —and because it does, this button appears to do precisely the same things that
the stan dar d Paste button doe s.
The first button in the second row is called No Borders (Figure 4–90):
Figure 4–90. Cells without borders: the No Borders button
and it copies all the source cell’s formats, except any borders that may be drawn around any or all sides
of the cell. Thus if I copy a cell like this, one which features borders around all its sides (Figure 4–91):
Figure 4–91. The cell with borders…
and paste it into another cell using No Borders, the paste will bring about this (Figure 4–92):
Figure 4–92. …can be pasted to another cell without the borders
Note the orange fill and altered font have been copied to the destination cell; but the borders have not.
And this button (Figure 4–93):