Microsoft KB Archive/93365

= Works: Adding a Constant to Range of Cells in Spreadsheet =

Article ID: 93365

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



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.

