Create a multiplication table

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021

To help a child better understand math concepts, create a multiplication table. 

  1. Enter numbers 1 through 10 in cells A2 to A11 and again in cells B1 to K1.
    Image of multiplication-table-1.

  2. Enter this formula in cell B2. The $ locks the value for the header row and the formula multiplies it by the value in the row.

    =$A2*B$1

  3. Copy cell B2.

  4. Select the range B2:K11.
    Image of multiplication-table-2.

  5. Paste the formula into those cells (Ctrl + V).
    Image of multiplication-table-3.