Microsoft Office Tutorials and References
In Depth Information
Cut and Paste, Digital Style
✓ Transpose (T): Excel changes the orientation of the pasted entries.
For example, if the original cells’ entries run down the rows of a single
column of the worksheet, the transposed pasted entries will run across
the columns of a single row.
✓ Values (V): Excel pastes only the calculated results of any formulas in
the source cell range.
✓ Values & Number Formatting (A): Excel pastes the calculated results of
any formulas along with all the formatting assigned to the labels, values,
and formulas in the source cell range into the destination range. This
means that all the labels and values in the destination range appear
formatted just like the source range, even though all the original formulas
are lost and only the calculated values are retained.
✓ Values & Source Formatting (E): Excel pastes the calculated results of
any formulas along with all formatting assigned to the source cell range.
✓ Formatting (R): Excel pastes only the formatting (and not the entries)
copied from the source cell range to the destination range.
✓ Paste Link (N): Excel creates linking formulas in the destination range
so that any changes that you make to the entries in cells in the source
range are immediately brought forward and reflected in the
corresponding cells of the destination range.
✓ Picture (U): Excel pastes only the pictures in the copied cell selection.
✓ Linked Picture (I): Excel pastes a link to the pictures in the copied cell
The options that appear on the Paste Options palette are context sensitive.
This means that the particular paste options available on the palette depend
directly upon the type of cell entries previously copied to the Office Clipboard.
Additionally, you can access this same palette of paste options by clicking the
drop-down button that appears directly beneath the Paste button on the Ribbon
instead of clicking the Paste Options button that appears at the end of the
pasted range in the worksheet or pressing the Ctrl key on your keyboard.
Paste it from the Clipboard task pane
The Clipboard can store multiple cuts and copies from any program running
under Windows (not just Excel). In Excel, this means that you can continue to
paste stuff from the Clipboard into a workbook even after finishing a move or
copy operation (even when you do so by pressing the Enter key rather than
using the Paste command).
To open the Clipboard in its own task pane to the immediate left of the
Worksheet area (see Figure 4-10), click the Dialog Box launcher in the
lowerright corner of the Clipboard group on the Ribbon’s Home tab.