Calculation Issues

Multiply a Range of Excel Cells by 10

Nimra MalikNimra Malik Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Use Paste Special to Multiply an Excel Range by 10

Use this method to scale numeric cells in place without creating helper formulas.

1
Enter the multiplier

Type 10 in an empty cell outside the target range.

2
Copy the multiplier

Select the cell containing 10 and choose Copy from the Home tab or right-click menu.

3
Select the target range

Select the cells whose values you want to multiply.

4
Apply Multiply

Open Home > Paste > Paste Special, select Multiply under Operation, and click OK.

Check the results: The operation changes the selected cells in place. If the result is not what you intended, use Undo immediately.
Multiply values in WPS Spreadsheets

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. 1. Open the spreadsheet: Open your workbook in WPS Spreadsheets and identify the range to change.
  2. 2. Copy the multiplier: Enter 10 in an empty cell outside the target range, select it, and click Copy.
  3. 3. Select the values: Select the range you want to multiply.
  4. 4. Multiply the range: Open Paste Special from the Paste menu, choose Multiply under Operation, and click OK.
Multiply a selected range in one operationOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.