Apply a Calculation to Multiple Excel Cells at Once
Question details
Apply the same calculation to multiple Excel cells without editing each cell individually.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to multiply a selected range by a percentage or apply another operation to all cells at once.
- Observed behavior
- The desired result is a calculated range without manually adding an equals sign or editing every formula.
Identify the numeric cells to change and decide whether to replace their contents or put results in a separate range. For multiplication, enter the factor as a percentage such as 40%, not 40.
Use Paste Special to Multiply a Range
Use this method to apply the same operation directly to existing cells without a macro.
Type 40% in an empty cell and press Enter. Use a different factor if needed.
Select the cell containing 40% and press Ctrl+C, or choose Home > Copy.
Highlight the range you want to multiply. Exclude headers and cells you do not want to change.
Open Home > Paste > Paste Special, select Multiply under Operation, and click OK. Choose Add, Subtract, or Divide instead if that is the intended calculation.

Fill a Formula Down a Separate Column
Use a formula when you want to retain the original values and recalculate results when they change.
Create Formulas from Selected Values with a VBA Macro
Use this desktop Excel method when each numeric constant must become a formula in its original cell.
Apply the Same Calculation to a Range in WPS Spreadsheet
Use Paste Special in WPS Spreadsheet to multiply selected cells by a common factor without editing each cell individually.
- 1. Open the workbook: Open WPS Spreadsheet and choose Open to select your Excel workbook.
- 2. Enter and copy the factor: Type 40% in an empty cell, select it, and choose Copy.
- 3. Select the range: Highlight the cells you want to multiply, excluding headers and unrelated values.
- 4. Multiply the cells: Choose Home > Paste > Paste Special, select Multiply under Operation, and confirm with OK.

Frequently Asked Questions
How do I multiply a whole range by 40% in Excel?
Enter 40% in an empty cell and copy it. Select the target range, then choose Home > Paste > Paste Special > Multiply and click OK.
Can I keep the original values while calculating the results?
Yes. Enter a formula such as =A2*40% in an empty column, then drag the fill handle down to calculate the remaining rows.
Will the VBA macro change existing formulas?
The macro in this article skips cells that already contain formulas. It changes numeric constants, so exclude dates and other numeric cells you do not want to modify.
Why do I need to save the workbook as an XLSM file?
The XLSM format retains VBA macros. Choose File > Save As and select Excel Macro-Enabled Workbook if you want to keep the macro in the workbook.
Can I apply an operation other than multiplication?
Yes. In the Paste Special dialog, select Add, Subtract, or Divide under Operation instead of Multiply.




