If you need to modify multiple numbers at once, you can use the Paste Special feature of Excel. Although pasting only values or formatting are more common use cases of the Paste Special feature, it has more tricks in its pocket. In this guide, we’re going to show how to use Paste Special to multiply numbers in Excel.

Download Workbook

Paste Special Basics

Paste Special dialog can be accessed from the right-click context menu, or by pressing the Ctrl + Alt + V key combination instead of just Ctrl + V when pasting data.

How to use Paste Special to multiply numbers in Excel 01

The dialog contains all available paste methods. The options we are going to need for the purposes of article are under the Operation section.

How to use Paste Special to multiply numbers in Excel

Paste Special supports 4 main operations:

  • Add
  • Subtract
  • Multiply
  • Divide

You can select only one operation at a time when pasting. Excel adds the copied cell value or formula to the target cells with the selected operation. Let’s see this functionality with some examples.

How to use Paste Special to multiply numbers in Excel

Let’s say you have a set of cells that you want to multiply by 1.1. For this, do the following:

  1. Type 1.1 to a cell
  2. Copy the 1.1 cell
  3. Select the range of numbers
  4. Press Ctrl + Alt + V
  5. In the Paste Special dialog, select Multiply
  6. Click OK

All values in the range will be updated with their multiplied results. For example, 85.5 instead of 78.

How to use Paste Special to modify the nth number

What if you want to change the every nth number of a list? All you need to do is to create a range which replicates the single period of the cycle. For example, if you want to modify every 4th number, place 1 into the first 3 cells and actual modifier into the 4th.

  1. Copy the range
  2. Select the numbers you want to modify
  3. Paste special with multiply modifier



The copied range will be multiplied repeatedly. Because 1 is a multiplicative identity, the first 3 numbers of every 4-number remain the same.

If you want to modify each number with a different value, use a range of values that is equal to target range.