Microsoft Excel XP/X

Using the Paste Special Feature

Excel's standard Copy & Paste feature works for a wide variety of situations; however, there are occasions when it does not meet your needs. For example, if you want the results of a formula, but no longer need the formula itself, you can isolate the results using the Paste Special command. Additional Paste Special options include:

All (the default)
Formulas
Values
Formats
Comments
Validation
All except borders
Column widths
Formulas and number formats
Values and number formats

EXAMPLE: To copy and paste only the results of a formula:

Select the cells that you want to copy
From the Edit menu, select Copy
A moving border appears around your selection.
Select the first cell where the results should be pasted
From the Edit menu, select Paste Special...
The Paste Special dialog box appears.
In the Paste section, select Values
Click OK
The results of the formula are pasted into the selected cell(s).