Formula Errors

Multiply Excel Values by a Fixed Cell or Convert Them to Formulas

Steve KSteve K Nov 18, 2026 869 views

Question details

Multiply existing Excel values by a fixed cell without manually editing each cell, either as permanent values or as formulas.

Multiply Excel Values by a Fixed Cell or Convert Them to Formulas
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains existing values that need to be multiplied by the fixed multiplier in cell A121.
Observed behavior
The user wants to apply the multiplier to multiple cells at once, with formulas if ongoing recalculation is needed.
Before you start

Enter the multiplier in A121 and identify the cells to multiply. Keep A121 outside the target selection, and decide whether you need permanent values or formulas that recalculate.

Solution 1Recommended

Multiply the existing values with Paste Special

Use this method to replace the selected values with their multiplied results without creating formulas.

1
Copy the multiplier

Select cell A121 and press Ctrl+C, or right-click it and choose Copy.

2
Select the target cells

Select the cells containing the values to multiply, excluding A121.

3
Apply the operation

Right-click the selection and choose Paste Special. Under Paste, select Values; under Operation, select Multiply, and then click OK.

Multiply the existing values with Paste Special
Results do not update: The results are stored as values, so changing A121 later will not recalculate them.
Work with formulas in WPS Office

Multiply worksheet values with WPS Spreadsheets

Use a helper column in WPS Spreadsheets to multiply values by a fixed cell and keep the results linked to the original data.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Enter the multiplier: Select A121 and enter the multiplier, if it is not already there.
  3. 3. Create a formula: If your first value is in B2, select an empty cell such as C2 and enter =B2*$A$121.
  4. 4. Fill down: Select C2 and drag the fill handle down to apply the formula to the remaining rows.
Create formulas that update when the multiplier changesOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface with fill controlsGet started with a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

Will Paste Special Multiply create formulas?

No. Copy A121, select the target cells, and choose Paste Special > Values > Multiply to replace the values with calculated results. Use a helper column or VBA if you need formulas.

Why does the formula use $A$121 instead of A121?

The dollar signs make A121 an absolute reference, so it stays fixed when you fill the formula down or across.

Will changing A121 update the results?

Formulas such as =B2*$A$121 recalculate when A121 changes. Values produced by Paste Special Multiply do not.

Can I replace the original values with formulas in the same cells?

Yes. Select the numeric cells and run the VBA macro in this article. It replaces each selected numeric constant with a formula that includes the original value and $A$121.