Works: Adding a Constant to Range of Cells in Spreadsheet

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.

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.