Microsoft KB Archive/31951

= Mathematically Applying One Number to a Group of Cells =

Article ID: 31951

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q31951



SUMMARY
There are certain situations in Microsoft Excel when you need to apply an arithmetic operation to a large range of cells on your worksheet. Using the Paste Special command, you can add, subtract, multiply, or divide a range of cells with the contents of a cell that is copied to the clipboard.



MORE INFORMATION
The following example illustrates using the Paste Special command to change a set of positive values into negative values.


 * 1) Enter the following values into a new worksheet:

A1: 3 B1: 4

A2: 5 B2: 6

A3: 10 B3: 12
 * 1) Enter the value -1 into cell D1.
 * 2) Select cell D1.
 * 3) On the Edit menu, click Copy.
 * 4) Select cells A1:B3.
 * 5) On the Edit menu, click Paste Special.
 * 6) In the Paste Special dialog box, click Multiply. Click OK.

The values contained in cells A1:B3 are now negative.

NOTE: When this operation is performed, the formatting of the copied cell is also pasted into the selected range. To avoid pasting the formatting of the copied cell, click Values in the Paste Special dialog box.

Additional query words: 3.00 4.0 4.00 XL

Keywords: kbhowto KB31951

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.