Microsoft Office Tutorials and References
In Depth Information
Cutting and pasting
Pastes an image of the selected cells as a static graphic object.
Linked Picture Pastes an image of the selected cells as a dynamic graphic object. If
you make any changes to the original cells, the changes are reflected in the graphic
object. This is handy for monitoring remote cells.
Cutting and pasting
When you cut rather than copy cells, subsequent pasting places one copy in the selected
destination, removes the copied cells from the Clipboard, removes the copied data from its
original location, and removes the marquee. When you perform a cut-and-paste operation,
the following rules apply:
Excel clears both the contents and the formats from the cut range and transfers them
to the cells in the paste range. Excel adjusts any formulas outside the cut area that
refer to the cells that were moved.
The area you select for cutting must be a single rectangular block of cells. If you try
to select nonadjacent ranges, you get an error message.
Regardless of the size of the range you select before pasting, Excel pastes only the
exact size and shape of the cut area. The upper-left corner of the selected paste area
becomes the upper-left corner of the moved cells.
Excel overwrites the contents and formats of any existing cells in the range where
you paste. If you don’t want to lose existing cell entries, be sure your worksheet has
enough blank cells below and to the right of the cell you select as the upper-left
corner of the paste area to hold the entire cut area.
● You cannot use Paste Special after cutting. Furthermore, no “floating button” menus
appear when you paste after cutting.
Pasting selectively using Paste Special
Paste Special is quite possibly the most useful (and most used) power-editing feature. You
can use this feature in many ways, but probably the most popular way is copying the value
in a cell without copying the formatting or the underlying formula. After you copy a cell
or cells, click the Paste menu on the Home tab, and click Paste Special to display the Paste
Special dialog box, shown in Figure 8-3. (You must copy to use Paste Special. When you cut,
Paste Special is unavailable.) The most popular Paste Special actions are directly accessible
as commands on the Paste menu on the Home tab, as shown on the left in Figure 8-3.