IBM Lotus Symphony


Pasting the value of a formula

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:
  1. Copy the data of the cell where a formula is used.
  2. Select the cell to which you want to paste, and click Edit > Paste Special. The Paste Special window opens.
  3. In the Paste field of the Paste Special window, select Values.
  4. Click OK to close the window.

IBM® Lotus® Symphony™ Spreadsheets

To paste only the formula result, do the following steps:
  1. Copy the data of the cell where a formula is used.
  2. Select the cell to which you want to paste, and click Edit > Paste Special. The Paste Special window opens.
  3. 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.
  4. Click OK to close the window.

Product Feedback | Additional Documentation | Trademarks