Multiply numbers in a cell. To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50. Multiply a column of numbers by a constant number. Suppose you want to multiply each cell in

How to multiply multiple columns in Excel. To multiply more than two columns in Excel, you can use the multiplication formulas similar to the ones discussed above, but include several cells or ranges. For example, to multiply values in columns B, C and D,

With simple addition and multiplication formulas and few clicks and drags of the mouse, you can add the total of each column and find the product of the two columns. Step 1 Launch the Excel program, and open the spreadsheet you want to modify by left-clic