Paste Operations - Part II

PART 2: PASTE OPERATIONS

Paste option also comes with a handful of operations. We can Add, Subtract, Multiply and Divide while pasting a set of values. An example will illustrate it better.

A Sales Department has the following weekly sales data.

Now for instance the department manager has done an error in the quantity and the pricing on all days of the week. The below is the difference data.

Now the original data needs to be corrected. We just have to copy the error data ( quantity and price and paste in over the original data using paste special (Addition Option). The same could to done to multiple, divide or Subtract.

Shortcut Key:  

Add :      After Ctrl + C , Press Alt + E followed by S & D

Multiply:    After Ctrl + C , Press Alt + E followed by S & M

Divide:      After Ctrl + C , Press Alt + E followed by S & I

Subtract:  After Ctrl + C , Press Alt + E followed by S & S

Please post your feedback or any Queries.