Adding Values to Values
Let’s say you have an input cell that someone enters multiple values into eg
You may have many such cells.
Now let’s say you want to add 20 to all these cells but keep the original values that have been entered in those cells.
Paste Special to the rescue.
- Enter 20 in a blank cell and then copy the cell
- Select the cells you want to amend – you can hold the Ctrl key down to select multiple cells with the mouse
- Open the Paste Special dialog
- Click the options Values and Add – as per image below – then click OK – done!
The resulting formula will be something like