Paste Special Operations in Excel

by

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.

Worked Example:   How to calculate percent of goal in Excel

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.

Worked Example:   Dynamic Named Range in Excel

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.

Leave a Reply

Your email address will not be published.