If you are looking for some special tricks to make a multiplication table in Excel, youâ€™ve come to the right place. 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.

**Table of Contents**Expand

## Â How to Make Multiplication Table in Excel: 4 Methods

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.

**ðŸ“Œ Steps:**

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

`=C$4*$B5`

Here, we multiplied cell **C5** by cell **B5**.

- 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.

### 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**.

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

**Read More:** Multiplication Formula in ExcelÂ

### 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.

- 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.

### 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**.

- 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**.

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

**Download Practice Workbook**

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

## Conclusion

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

Keep learning new methods and keep growing!

## Related Articles

- How to Divide and Multiply in One Excel Formula

- How to Multiply from Different Sheets in Excel
- If Cell Contains Value Then Multiply Using Excel FormulaÂ
- Multiply Rows in Excel
- How to Multiply by Percentage in Excel
- How to Do Matrix Multiplication in Excel
- How to Multiply Multiple Cells in Excel
- How to Multiply Two Columns in ExcelÂ

- How to Multiply Two Columns and then Sum in Excel

**<< Go Back to Multiply in Excel | Calculate in ExcelÂ | Learn Excel**