Works: Replacing a Formula with a Constant in Spreadsheet (93355)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
  • Microsoft Money 2000 Business and Personal
This article was previously published under Q93355

SUMMARY

In the spreadsheet module of Microsoft Works for Windows, a formula can be replaced with its numeric result using the following procedure:

  1. Select the range of cells containing the formulas to be replaced.
  2. From the Edit menu, click Copy.
  3. Leaving the area highlighted, click Paste Special from the Edit menu.
  4. In the Paste Special dialog box, select Values Only and click OK.
The selected area will now contain only numbers and no formulas.

MORE INFORMATION

For example, if cell C10 contained the formula =A10+B10, and cells A10 and B10 10 and 20 respectively, the value of C10 would change whenever A10 or B10 was changed. However, using the Paste Special command and the method above, the contents of cell C10 would be made a constant 30.

REFERENCES

For more information about how to perform this task in Works for Windows 95, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0, pages 180-181

"Microsoft Works for Windows User's Guide," version 2.0, pages 121-122
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB93355
©2004 Microsoft Corporation. All rights reserved.