Microsoft Office Tutorials and References
In Depth Information
Moving Cells Around
if you paste cell A2 as a link into cell B4, the cell B4 contains the reference =A2.
You’ll learn more about cell references and get to the bottom of this strange trick
in Chapter 17.)
• Picture. This option pastes a picture of your cell, which is more than a little odd.
The picture is placed right in the worksheet, with the formatting and borders
you’d expect. In fact, if you don’t look closely, this picture looks almost exactly
like ordinary Excel data. The only way you’ll know that it isn’t is to click it. Unlike
ordinary Excel data, you can’t edit the data in a picture; instead, you’re limited to
resizing it, dragging it around your worksheet, and changing its borders.
Note: Although it might make sense to copy a picture of your worksheet into other programs, there’s little
reason to use the picture-pasting feature inside an Excel spreadsheet.
• Linked Picture. This option is the same as Picture, except Excel regenerates the
picture whenever you modify the values of formatting in the source cells. This
way, the picture always matches the source cells. Excel experts sometimes use
this feature to create a summary that shows the important parts of a massive
spreadsheet in one place. But in the wrong hands, this feature is a head-scratching
trick that confuses everyone.
At the very bottom of the menu with paste options is a command named Paste
Special. This brings up another window, with more esoteric pasting options. You’ll take
a peek in the next section.
Once you become familiar with the different paste options, you don’t need to rely on
the ribbon to use them. Instead, you can use them after a normal copy-and-paste.
After you insert your data (by pressing Enter or using the Ctrl+V shortcut), look for the
small paste icon that appears near the bottom-right corner of the pasted region. (Excel
nerds know this icon as a smart tag .) If you click this icon (or press the Ctrl key), Excel
pops open a menu (Figure 15-9) with the same set of paste options you saw earlier.
Note: The paste icon appears only after a copy-and-paste operation, not a cut-and-paste operation. If you
paste cells from the Clipboard panel, the paste icon still appears, but it provides just two options: keeping
the source formatting or pasting the data only.
The paste options in the ribbon are practical and powerful. But Excel has
even more paste options for those who have the need. To see them all, choose
Home ➝ Clipboard ➝ Paste ➝ Paste Special to pop open a dialog box with a slew of
options (Figure 15-10).