![]() ![]() Please browse for more details.īefore applying Kutools for Excel, please download and install it firstly.ġ. The Operation tool of Kutools for Excel will help you easily mass multiply or divide all values in a column or range by a certain number in Excel. ![]() You can see the operation result as below screenshot shown. 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. ![]() Select the number list you need to batch multiply, then click Home > Paste > Paste Special. Copy this cell with pressing the Ctrl + C keys simultaneously.Ģ. 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). You can multiply or divide all values in a column by a certain number as follows.ġ. Mass multiply or divide all values in a column by a number in ExcelĮasily multiply or divide all values in a column by a number with Kutools for Excel 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. Normally, you need to calculate them one by one with formulas. How to mass multiply or divide all values in a column by a number in Excel?įor a list of numbers, you may need to multiply by a certain number for each of them as below screenshot shown. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |