Works: Adding a Constant to Range of Cells in Spreadsheet (93365)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • 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 Q93365

SUMMARY

In the spreadsheet module of Microsoft Works for Windows, a number can be added to or subtracted from each cell in a range of cells by using the Paste Special command. The usual method of adding a number to or subtracting a number from a range of cells is to use formulas; however, formulas must be entered in separate cells.

The following procedure will add to or subtract from a range of cells in place.

NOTE: Any formulas in the selected area will be lost.

  1. In a blank cell, enter the value to be added or subtracted to all the cells in a desired range.
  2. On the Edit menu, click Copy.
  3. Select the range of cells you're modifying.
  4. On the Edit menu, click Paste Special.
  5. To add the value to all the cells, click Add Values; to subtract value to all cells, click Subtract Values.
The selected area now contains the results of the addition or subtraction operation.

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 KB93365
©2004 Microsoft Corporation. All rights reserved.