You can transform selected cells in a spreadsheet. Transforming is a way of adding, subtracting, multiplying or dividing two ranges.
To transform an area of the spreadsheet - the target range- first type in and select the range of cells you wish to use to effect the transformation. Then select Copy from the toolbar (or the Edit menu, or by right clicking your mouse).
Next, select the target range and then select the Paste Special command from the Edit menu (or by right clicking your mouse). In the Operation group box, click on the Add, Subtract, Multiply or Divide button. Click on the Paste button and the spreadsheet will be redrawn with the data transformed.
Example 1
The target range contains 1, 2, 3, 4, 5, which you want to multiply by 2. Enter 2 into a spreadsheet cell and Copy this cell. Select the target range and then select Paste Special. Select Multiply and then click on the Paste button. Each of the target cells will be multiplied by 2 to give 2, 4, 6, 8, 10.
Example 2
The target range contains 25, 20, 15, 10, 5, which you want to divide by 5, 4, 3, 2, 1, the transformation range. Type in and select the transformation range. Copy this range and then select the target range. Select Paste Special and click on Divide. Click on the Paste button. The values in the target range will be divided by the corresponding values in the transformation range to give 5, 5, 5, 5, 5.