Microsoft Office Tutorials and References
In Depth Information
Copying and pasting
If you select a paste range that contains more cells than the copied range, Excel repeats
the copied cells until it ills the destination. However, if you select a paste range that is
smaller than the copied range, Excel pastes the entire copied range anyway.
Using the Paste Options button
Notice in Figure 8-2 that we clicked the floating Paste Options button that appears near
the lower-left corner of the pasted range. This button appears whenever and wherever you
paste, offering actions applicable after pasting—a sort of “Smart Paste Special.” (Similar
floating buttons offering context-triggered options appear after performing actions other
than pasting, too.) The best part is that you can try each action in turn. Keep selecting paste
options until you like what you see, and then press Enter. The following describes the most
interesting items on the Paste Options menu:
Pastes all cell contents, including formulas, but no formatting.
Formulas And Number Formatting Pastes all cell contents, including formulas
and number formats, but no text formats.
Pastes everything but borders.
Flips a column of data into a row and vice versa.
Values Pastes cell contents and the visible results of formulas (not the formulas
themselves) without formatting.
Values And Number Formatting Pastes cell contents and the visible results of
formulas (not the formulas themselves); retains number formats, but not text formats.
Values And Source Formatting Pastes cell contents and the visible results of
formulas (not the formulas themselves), plus all the copied or cut formats.
Keep Source Column Widths Retains column widths. This option is like normal
pasting with the added action of “pasting” the column width.
Formatting Leaves the contents of the destination cells alone, and transfers the
formatting. This works in the same way as the Format Painter button, located in the
Clipboard group on the Home tab.
Paste Link Instead of pasting the contents of the cut or copied cells, pastes a
reference to the source cells, ignoring the source formatting.