Explanation
This formula is designed to be copied throughout the interior of the multiplication table without change.
They are harder to set up, but make formulas much easier to enter.
Multiplication table formula
Building a multiplication table in Excel is a classic problem because it requires a "mixed reference" – a reference that is partially absolute, partially relative. In the example shown, the formula in C5 is: =$B5*C$4 Note both cell references have absolute and relative elements, so they are referred to as "mixed references".
