How to Multiply Two Columns in Microsoft Excel
- George Apostolov
How to Multiply Two Columns in Microsoft Excel: step-by-step guide
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.
Quick answer: 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.
About this Microsoft tutorial
Multiply two columns in Microsoft Excel by entering a formula with cell references and an asterisk, then dragging the fill handle. This guide shows how to multiply Two Columns in Microsoft Excel in 7 steps, starting with "Inside your Microsoft Excel worksheet, select a cell next to the two columns you wish t..." and finishing with "After completing these steps, the values of the two selected columns will be multiplied...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to multiply Two Columns in Microsoft Excel?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Pin Microsoft Planner Plans to the Taskbar, How to Plot the Microsoft Excel Data on a Line Chart and How to Print Gridlines in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
