Multiply Excel Values by a Fixed Cell or Convert Them to Formulas
Question details
Multiply existing Excel values by a fixed cell without manually editing each cell, either as permanent values or as 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.
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.
Multiply the existing values with Paste Special
Use this method to replace the selected values with their multiplied results without creating formulas.
Select cell A121 and press Ctrl+C, or right-click it and choose Copy.
Select the cells containing the values to multiply, excluding A121.
Right-click the selection and choose Paste Special. Under Paste, select Values; under Operation, select Multiply, and then click OK.

Create formulas in a separate column
Use a helper column when you want results to update as the original values or multiplier change.
Convert selected values to formulas with VBA
Use a macro when formulas must replace the existing values in their original cells.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Enter the multiplier: Select A121 and enter the multiplier, if it is not already there.
- 3. Create a formula: If your first value is in B2, select an empty cell such as C2 and enter =B2*$A$121.
- 4. Fill down: Select C2 and drag the fill handle down to apply the formula to the remaining rows.

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.




