Question: how to create a multiplication table in excel with 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.