The steps I used is:
- Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1.
- Enter formula
=$A2*B$1
in cell B2 - Copy cell B2.
- Select the range B2:K11.
- 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?