Building a Multiplication Table

The multiplication table is the perfect proving ground for mixed references. The goal: write one formula, copy it across the whole grid, and have every cell show the right product.

If you understand this, you understand mixed references for good. Let's build it step by step.

First lay out the headers. Put the numbers 1 through 10 across the top in row 1, from B1 to K1. Put the numbers 1 through 10 down the side in column A, from A2 to A11.

The cell where row meets column, like B2, will hold the product of its row label and column header.