Excel: Mathematically Applying One Number to a Group of CellsLast reviewed: October 27, 1997Article ID: Q31951 |
The information in this article applies to:
SUMMARYThere 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 INFORMATIONThe following example illustrates using the paste special command to change a set of positive values into negative values.
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 reference words: 3.00 4.0 4.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |