Jump to content

Perform calculations with Paste Special


Recommended Posts

Perform calculations with Paste Special

Most Excel users know how to convert formulas to values with the Paste Special function. This function also makes it easy to perform mathematical operations on a range of cells "in place."

Let's say you've entered some numbers in a range of cells, and now you want to double those values. You could write a formula elsewhere in the sheet that multiplies the values in the original cells by two, copy the cells with the formulas, and use Paste Special | Values to overlay the new values in the original cells. However, you'd have to delete the work cells that contained the doubling formula.

To eliminate this extra step, follow these steps:

1. Select the cells whose values you want to double, and press [Ctrl]C.

2. Go to Edit | Paste Special.

3. Select Add in the Operation section, and click OK.

Excel adds the values you copied to the values contained in the target cells, which doubles the original values.

This feature is also useful when you want to update a range of cells using the values from a completely different range of cells. Just select and copy the first set of values, click the first cell in the target range, and go to Edit | Paste Special. From there, select Add, Subtract, Multiply, or Divide, and then click OK. Excel will update the target cells with the calculation results.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...