Sometimes you use a formula to calculate a certain data
range, and you want to paste only the result of the formula to somewhere
else.
Microsoft® Excel
2003
To paste only the formula result, do the following
steps:
- Copy the data of the cell where a formula is used.
- Select the cell to which you want to paste, and click . The Paste Special window opens.
- In the Paste field of the Paste Special
window, select Values.
- Click OK to close the window.
IBM® Lotus® Symphony™ Spreadsheets
To
paste only the formula result, do the following steps:
- Copy the data of the cell where a formula is used.
- Select the cell to which you want to paste, and click . The Paste Special window opens.
- In the Selection field of the Paste Special
window, make sure that the Paste All check
box and the Formulas check box are cleared,
and the Numbers check box is selected.
- Click OK to close the window.