Question: how to make a multiplication table in excel using one formula?
Answer: Select cell C3 and click on it.
Insert the formula: = $B3 * C$2.
Press enter.
Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.
Select the range C3:C12.