How to Make Multiplication Table in Excel (4 Methods)

If you are looking for some special tricks to make a multiplication table in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to make a multiplication table in Excel. In this article, we’ll discuss four methods to make a multiplication table in Excel. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Methods to Make Multiplication Table in Excel

We will use four effective and tricky methods to make a multiplication table in Excel. This section provides extensive details on four methods.  You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Make Multiplication Table Using Mixed References

Here, we have a dataset containing numbers 1-10 in the range of cells C4:L4 and again in the range of cells B5:B14. Our main goal is to make a multiplication table. To do this we will use the simple method using mixed cell references. In this method, the row reference is locked while the other is not. You have to follow the following steps to make a multiplication table.

Make Multiplication Table Using Mixed References

📌 Steps:

  • Firstly, you have to use the following formula in cell C5:

=C$4*$B5

Here, we multiplied cell C5 by cell B5.

Make Multiplication Table Using Mixed References

  • Next, copy cell C5. Then you have to select the range of the cells C5:L14 and paste (Ctrl+V) the formula.

  • Finally, you will get a complete multiplication table like the following.

Make Multiplication Table Using Mixed References

Read More: How to Do Matrix Multiplication in Excel (5 Examples)


2. Applying Array Formula

Using an array formula to make a multiplication is another simple and quickest method. You have to follow the following steps:

📌 Steps:

  • Firstly, you have to use the following formula in cell C5:

=B5:B14*C4:L4

  • Press Enter.

Create Multiplication Table Using Array Formula

  • Finally, you will get a complete multiplication table like the following.

Create Multiplication Table Using Array Formula

Read More: Multiplication Formula in Excel (6 Quick Approaches)


Similar Readings


3. Using IF Function in Excel

Here is another method to make a multiplication table using the IF function. IF function checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. You have to follow the following steps:

📌 Steps:

  • Firstly, you have to use the following formula in cell C5:

=IF(C$4>$B5,C$4*$B5,C$4*$B5)

Here, the IF function checks the condition whereas cell C4 is greater than cell B5. If the condition is met, it returns the result of multiplying cell C4 by B5, and if not it will also return the same value.

Using IF Function in Excel

  • Next, copy cell C5. Then you have to select the range of the cells C5:L14 and paste (Ctrl+V) the formula.

Using IF Function in Excel

  • Finally, you will get a complete multiplication table like the following.

Read More: What is the Formula for Multiplication in Excel for Multiple Cells? (3 Ways)


4. Embedding VBA Code to Create Multiplication Table

By using a simple code, you will be able to make a multiplication table. You have to follow the following steps.

📌 Steps:

  • Firstly, press Alt+F11 to open the VBA editor. Select Insert > Module.

Embedding VBA Code to Make Multiplication Table

  • Next, you have to type the following code:
Sub Multiplication_table()
 Range("C5").Select
 For a = 1 To 10
 For b = 1 To 10
 ActivateCell.Offset(a - 1, b - 1).Value = a * b
 Next b
 Next a
End Sub
  • After that, close the Visual Basic window, and press ALT+F8.
  • When the Macro dialogue box opens, select Multiplication_table in the Macro name. Click on Run.

Embedding VBA Code to Make Multiplication Table

  • Finally, you will get a complete multiplication table like the following.

Read More: How to Multiply in Excel: Columns, Cells, Rows, & Numbers


Conclusion

That’s the end of today’s session. I strongly believe that from now you may make a multiplication table in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo