» Adding, Subtracting, Multiplying and Dividing Without Using Formulas
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
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.
Book Store:
No comments have been submitted.
