|  

» Adding, Subtracting, Multiplying and Dividing Without Using Formulas

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


Rate This Tip
12 34 5
Rating: 2.90     Views: 42134
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments