# Excel: Create a Multiplication Table

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I want to create a multiplication table to help my kids in school. I want to be able to enter a single formula in cell B2 that I can copy to the entire table. 1. Need a formula to point to row 1 and column 1.

Strategy: In "Copy a Formula While Keeping One Reference Fixed," you learned how to use an absolute reference, such as \$C\$1, so that Excel would not change from column C or row 1 as it copied the formula. To create a multiplication table, you need to use a mixed reference. A mixed reference, such as \$A2, will lock the formula to column A while allowing the row to change. A mixed reference, such as B\$1, will lock the row to row 1 while allowing the column to change.

The formula you need for the multiplication table is a formula that will multiply whatever is in row 1 above the cell by whatever is in column A to the left of the cell.

To have a reference that always points to row 1, you use something in the format of B\$1. To have a reference that points to column A, you use a reference in the format of \$A2.

1. Enter the formula =\$A2*B\$1 in B2. 2. Multiply column A by row 1.
1. Copy the formula in B2 to the entire range.

Result: Excel will always properly multiply column A by row 1. 3. =\$A13*M\$1 creates the multiplication table.