It is very easy to multiply two columns in Microsoft Excel. Here’s a quick tutorial on how to do it:
- Inside your Microsoft Excel worksheet, select a cell next to the two columns you wish to multiply and then type an 'Equals' sign (=).
- After that, type the reference cell containing the first factor of the operation.
- Type an 'Asterisk' sign (*) afterwards.
- Subsequently, enter the cell reference containing the other factor.
- Once done, click anywhere around your worksheet to run the formula and get the results.
- Head back to the selected cell afterwards and grab the 'Fill' handle at the bottom-right corner. Drag it downward to copy the formula to the other cells below.
- After completing these steps, the values of the two selected columns will be multiplied by one another.
