Chapter 4: Working with Cells and Ranges
87
Note
After you paste, you’re offered another chance to change your mind. A Smart Tag appears at the lower right of
the pasted range. Click the Smart Tag (or press Ctrl), and you see the paste option icons again. n
Using the Paste Special Dialog box ............................................................................
For yet another pasting method, choose Home ➪ Clipboard ➪ Paste ➪ Paste Special to display
the Paste Special dialog box (see Figure 4.11). You can also right-click and choose Paste Special
from the shortcut menu to display this dialog box. This dialog box has several options, which I
explain in the following list.Note
Excel actually has several different Paste Special dialog boxes, each with different options. The one displayed
depends on what’s copied. This section describes the Paste Special dialog box that appears when a range or
cell has been copied. n
FIGURE 4.11The Paste Special dialog box.
Tip
For the Paste Special command to be available, you need to copy a cell or range. (Choosing Home ➪
Clipboard ➪ Cut doesn’t work.) n
l All: Pastes the cell’s contents, formats, and data validation from the Windows Clipboard.l (^) Formulas: Pastes values and formulas, with no formatting.
l Values: Pastes values and the results of formulas (no formatting). The destination for the
copy can be a new range or the original range. In the latter case, Excel replaces the origi-
nal formulas with their current values.