Create Time / Multiplication Table

The steps I used is:

  1. Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1.
  2. Enter formula =$A2*B$1 in cell B2
  3. Copy cell B2.
  4. Select the range B2:K11.
  5. Paste the formula into those cells (Crtl + V).

The resulting output is:

However, I want the output to look like

1 x 1 = 1 1 x 2 = 2 1 x 3 = 3
2 x 1 = 2 2 x 2 = 4 2 x 3 = 6
3 x 1 = 3 3 x 2 = 6 3 x 3 = 9

How can I do that?

=$A2&" x "&B$1&" ="&$A2*B$1

1 Like

Thank you very much.