How to Multiply Two Columns in Microsoft Excel
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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it