Microsoft Office Tutorials and References
In Depth Information
Moving Cells Around
The paste icon appears following
the completion of every paste
operation, letting you control
a number of options, including
whether the formatting matches
the source or destination cells.
The icon remains until you start
typing in another cell, which
means you can change the type
of paste several times, until you
get exactly the result you want.
The only disadvantage is that
this menu doesn’t have the same
preview feature that the ribbon
The Paste Special dialog box allows you to choose exactly
what Excel will paste, and it also lets you apply a few other
settings. The big drawback is that you don’t get a preview,
and some of the options are less than clear. In this example,
Excel will perform an ordinary paste with a twist; it won’t
bother to copy any blank cells.
Paste Special is a bit of a holdover from the past. Many of its options are duplicated in
the ribbon’s drop-down Paste list. However, the Paste Special dialog box allows you
to do a few things that aren’t possible from the ribbon, including:
• Paste comments . Choose Comments in the Paste section, and click OK. This
leaves all the text and formatting behind but copies any comments you’ve added
to the cells.