# How to Multiply Two Columns in Microsoft Excel

> To multiply two columns in Microsoft Excel, select a cell, type an equals sign, enter the first cell reference, type an asterisk, and add the second cell reference. Click to run the formula, then drag the fill handle downward to copy it to the other cells.

Canonical: https://livedemo.ai/tutorials/how-to-multiply-two-columns-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4a0aab56e05a00ff5151/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, select a cell next to the two columns you wish to multiply and then type an 'Equals' sign (=).
2. After that, type the reference cell containing the first factor of the operation.
3. Type an 'Asterisk' sign (*) afterwards.
4. Subsequently, enter the cell reference containing the other factor.
5. Once done, click anywhere around your worksheet to run the formula and get the results.
6. 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.
7. After completing these steps, the values of the two selected columns will be multiplied by one another.