Multiply a Range of Excel Cells by 10
Question details
Multiply all values in a selected range of Excel cells by 10 without editing each cell individually.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to scale a range of spreadsheet values by a factor of 10 without creating helper formulas.
- Observed behavior
- Each selected numeric value should be multiplied by 10 in place.
Identify an empty cell outside the range you want to change and check that the target cells contain the values you intend to multiply. Paste Special changes the selected cells in place and can modify existing formulas.
Use Paste Special to Multiply an Excel Range by 10
Use this method to scale numeric cells in place without creating helper formulas.
Type 10 in an empty cell outside the target range.
Select the cell containing 10 and choose Copy from the Home tab or right-click menu.
Select the cells whose values you want to multiply.
Open Home > Paste > Paste Special, select Multiply under Operation, and click OK.
Multiply a Range by 10 in WPS Spreadsheets
Use Paste Special in WPS Spreadsheets to multiply selected values by 10 in place, without adding helper formulas.
- 1. Open the spreadsheet: Open your workbook in WPS Spreadsheets and identify the range to change.
- 2. Copy the multiplier: Enter 10 in an empty cell outside the target range, select it, and click Copy.
- 3. Select the values: Select the range you want to multiply.
- 4. Multiply the range: Open Paste Special from the Paste menu, choose Multiply under Operation, and click OK.

Frequently Asked Questions
Can I multiply a range by a number other than 10?
Yes. Enter the desired multiplier in an empty cell, copy it, select the target range, and choose Multiply in Paste Special.
Does Paste Special create helper formulas?
No. Paste Special applies the multiplication directly to the selected cells instead of creating formulas in a separate range.
What happens if the selected range contains formulas?
Paste Special can modify the formulas as part of the multiplication. Check the affected cells afterward and use Undo if the changes are not intended.
How do I undo the multiplication?
Use Undo on the Quick Access Toolbar or press Ctrl+Z immediately after applying Paste Special.




