Paste Special in Excel allows you to quickly add, subtract, multiply, divide to and from a cell series in-place without having to create a new cell series and write a formula.
Use the ‘Paste Special Operations’ to quickly perform operations on a range of cells in Excel.
1. Select cell D3.
2. Right click, and then click Copy.
3. Select the range A1:B8.
4. Right click, and then click Paste Special.
5. Click Multiply.
Note: you can also Divide, Add or Subtract a value.
6. Click OK.
Note: all values are increased by 10 percent. Without this feature, you would have to create a temporary range (with formulas that multiply the values in the range A1:B8 by 1.1) and then replace the range A1:B8 by copy and pasting the temporary range as values.