Adding Values to Values

Let’s say you have an input cell that someone enters multiple values into eg

=10+5+34

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.

  1. Enter 20 in a blank cell and then copy the cell
  2. Select the cells you want to amend Рyou can hold the Ctrl key down to select  multiple cells with the mouse
  3. Open the Paste Special dialog
  4. Click the options Values and Add – as per image below – then click OK – done!

The resulting formula will be something like

=(10+5+34)+20

 

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *