Accomplish two tasks at once with the Paste Special command (Microsoft Excel 97/2000/2002/v. X/2003)

The Paste Special command offers several options for effectively controlling what and how you paste your Excel data. One of those options includes performing calculations with the data you're ready to paste and the data in the cells to which you're pasting.

For example, let's say you'd like to copy the Quarter 1 Sales to another cell in your worksheet and then add the copied value to the figure in the cell where you're pasting. You can do it all in one step. Select the cell and press [Ctrl] C ([command] C in v. X) to copy it. Then, select the cell containing the value with which you'd like to sum the copied data. Choose Edit | Paste Special from the menu bar to access the Paste Special dialog box. Then, select the Add option button in the Operation panel and click OK. The new cell's original value is overwritten with the sum of the two values. So, as long as you're aware that you can't preserve the value in the cell or range to which you're pasting, you can perform simple operations while you move data. In addition to summing, you can also multiply, subtract, and divide.