# 30+ Copy & Paste Tricks You Must Know – Mouse Keyboard Autofill Paste Special and More!

2
11911

### 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:

### 28. Subtract

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.

### 29. Multiply

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.

### 30. Divide

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.

SHARE
Previous articleMaking Aging Analysis Reports Using Excel – How To
Next articleWhat is Working Capital?
Teaching professional business subjects to the students of FIA, ACCA, CIMA, CA etc. He also found ACCA LIVE which is Pakistan's first portal to provide online classes and distance learning solutions to FIA/ACCA students. At PakAccountants.com he is busy making study material for different qualifications. Beside writing articles he answers questions asked using ASK TUTOR!