Excel: Mathematically Applying One Number to a Group of Cells

Last reviewed: October 27, 1997
Article ID: Q31951

The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0
  • Microsoft Excel version 7.0 for Windows 95
  • Microsoft Excel 97 for Windows

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
    
    

  2. Enter the value -1 into cell D1.

  3. Select cell D1.

  4. Click Copy in the Edit menu.

  5. Select cells A1:B3.

  6. Click Paste Special on the Edit menu.

  7. In the Paste Special dialog box, click Multiply, then 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 reference words: 3.00 4.0 4.00
Keywords : kbusage
Version : MACINTOSH:3.0,4.0,5.0; WINDOWS:3.0,4.0,5.0,7.0,97
Platform : MACINTOSH WINDOWS
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.