Paste Special is the gateway into many powerful operations in calculations of the data which will helps to save lot of time where we can able to Add,Subtract,Multiply and Divide the the data in single click without using formula.
First we need to copy the value which we need to add,subtract ,multiply and divide and select the area and click on the paste special option and click on the operation option which we required result
Addition option of Paste Special
Subtraction option of Paste Special
Multiply option of Paste Special
Division option of Paste Special
Video Link: Watch Video