Multiplication Table Challenge

Feeling up to a challenge?

Here is a challenge for you to complete in Excel.

Can you come up with a formula in cell B2 below that can be copied down and across the rest of the table below?

  • From cell B1 across to K1, list the numbers 1 to 10
  • From cell A2 down to A11, list the numbers 1 to 10
  • In B2 enter a formula that can be copied and pasted to the remaining cells making a multiplication table

multiplication table layout for challenge



Hint: You will need mixed references


Were you able to complete this?  We will post the solution next week.


[grwebform url=”” css=”on”/]
Click Here to Leave a Comment Below 1 comments

Get every new post delivered to your Inbox

Join other followers:

%d bloggers like this: