So in your case: Copy D2 Select B5 to your MAX Paste Special -> Multiply Should look correct The following example shows how to use this formula in practice. if ( dropdown.options[ dropdown.selectedIndex ].value > 0 ) { Drag Cell E1's AutoFill handle right to Cell G1, and then drag down to the Cell G8. In this article, we have tried to cover all the possible ways to multiply columns in Excel. Excel Formulas Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Select all the cell in column A with which you want to multiply the number, Right-click on the selected cells and then click on Paste Special option, In the Paste Special dilaog box that opens, select the Multiply option in Operations. Excel Basics Thank you. 127) into an Excel column (e.g. Sometimes, we need to multiply columns in Excel. He or she will need to multiply the Quantity by Price per Unit and Percentage after Discount column. We will get the corresponding values in the Total column. 3. Set up a column of numbers you want to multiply, and then put the constant in another cell. Now see that the full column has been multiplied by the number 3. Click the second cell you want to multiply. 9 Useful and Easy Ways to Multiply Columns in Excel 1. Click the second cell you want to multiply. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Drag the formula in B2 down to the other cells in column B. Practice with VBA Select cell E5 and type *3 then hit the Enter button.