Adding, Subtracting, Multiplying and Dividing Without Using Formulas

by  About
       

To carry out simple mathematical calculations, use Paste Special Operation:

1. In this example, assume that columns C and D are sales figures to be added together.
2. Copy column C.
3. Select column D.
4. Press Shift+F10 or right-click, and then select Paste Special from the shortcut menu.
5. In the Operation area, select the Add option button, and then click OK. The figures from column C are added to those in column D.
Screenshot // Adding, Subtracting, Multiplying and Dividing Without Using Formulas
Adding, Subtracting, Multiplying and Dividing Without Using Formulas



Leave a Reply

Your email address will not be published. Required fields are marked *


× four = 16

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>