Paste Special – Conducting mathematical operations using copy/paste
Amazed? Yes it is totally cool! I too never imagined when I first learnt about it that how can we do mathematical operations like add/subtract/multiply or divide by simply copying and pasting. But it is totally possible with paste special facility. To learn how to do it read on.
Have a number that you want to add in any cell and copy that cell. Then select the cell or range of cells to which you want to add and hit Alt+Ctrl+V and from the dialogue box under operation group select Add option and click OK. You are done 🙂
27. Bonus Tip – Add multiple numbers to multiple cells
In above example we added a single number to a single or multiple cells. However, if you have several numbers to add to several other cells then you can do this too using the same feature. Following animation explains:
Have a number in any cell that you want to subtract from cell or cells. Copy it. Select the cells on which you want to perform subtract operation and bring paste special dialogue box up and this time select Subtract and click OK button.
The bonus tip discussed under Add applies for subtract as well.
Get a number in cell that you want to multiple to select cell or cells. Copy it. Go to cell or cells with which you want the product, select them, open paste special dialogue box and select Multiply option from Operations group and click OK button.
Again, the bonus tip discussed under Add operation above applies to this operation as well.
Type the number with which you want divide the values of specific cells and copy it using keyboard or mouse. Select the values of desired cells on which you want to apply Divide operation and open paste special dialogue box using Alt+Ctrl+V shortcut and under operations group select Divide radio button and click OK. Your values will be factored!
Bonus tip discussed under Add applies for this math operation too.