How to Create Multiplication Facts in Excel

Excel automatically creates multiplication tables.

Although complicated multiplication problems can be worked out on paper, multiplying single-digit numbers relies on memorized facts. As an example, unless you want to waste a considerable amount of time adding 9 nine times, you need to know that 9 times 9 equals 81. Creating a multiplication table in Microsoft Excel helps you memorize these multiplication facts by arranging a series of columns and rows, which can be referenced to find the answer for single-digit multiplication.

Instructions

1. Open Microsoft Excel.

2. Enter "1" without quotes in cells "A1" and "A2."

3. Enter "=A1*A2" without quotes in cell "A3."

4. Enter the numbers 1 through 10 in cells "B3" through "K3," respectively.

5. Enter the numbers 1 through 10 in cells "A4" through "A13," respectively.

6. Click and drag your mouse from cell "A3" to "K13" to select everything between those cells.

7. Click the "Data" tab.

8. Click "What-If Analysis" from the "Data Tools" group and select "Data Table."

9. Enter "A1" without quotes in the "Row Input Cell" field of the table.

10. Enter "A2" without quotes in the "Column Input Cell" field of the table.

11. Click "OK" to create a multiplication table.

References

• Microsoft: Create a Multiplication Table