How to mass multiply or divide all values in a column by a number in Excel?
For a list of numbers, you may need to multiply by a certain number for each of them as below screenshot shown. Normally, you need to calculate them one by one with formulas. In this article, we will show you two methods to quickly multiply or divide all values in a column by a number at once in details.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
You can multiply or divide all values in a column by a certain number as follows.
1. Enter the certain number in a blank cell (for example, you need to multiply or divide all values by number 10, then enter number 10 into the blank cell). Copy this cell with pressing the Ctrl + C keys simultaneously.
2. Select the number list you need to batch multiply, then click Home > Paste > Paste Special. See screenshot:
3. In the Paste Special dialog box, select the Multiply or Divide option in the Operation section as you need (here we select the Multiply option), and then click the OK button.
You can see the operation result as below screenshot shown.
After free installing Kutools for Excel , the Operation tool will help you easily mass multiply or divide all values in a column or range by a certain number in Excel. Please browse for more details.
|Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.|
1. Select the column with values you need to batch multiply or divide by a number, then click Kutools > More > Operation. See screenshot:
2. In the Operation Tools dialog box, select the operation type you need in the Operation box (here we select Multiplication option), enter the certain number for the multiplication operand into the textbox, and then click the OK button.
1. You can create formulas for the list with checking the Create formulas box.
2. If there already have formulas in the list, you can skip calculating these cells by checking the Skip formula cells box.
Then all selected cells are multiplied with a certain number at once.
|If this utility is helpful, you can download and try the free trial now!|