Excel for Marketing Managers

Multiplication Tables

Multiplication

Tables

Entering a Single Formula for Many Cells

With a little thought, you can usually write one formula that can be copied to
many cells. If you think about the formula that is needed to populate the
interior of the multiplication table, you could express it this way:
For any cell, multiply the number found in row 1 above the cell with the number found
in column A to the left of the cell.

One such formula would be =C1*A5, as shown in cell C5.

While the preceding formula will work just fine in cell C5, it will not work
when you copy the formula to any other cell in the table. Figure 73 shows the
formula after it has been copied to D6. The reference that used to point to C1 is
now pointing to D2. The reference that used to point to A5 is now pointing to
B6. This is called a Relative reference and it is by design in Excel.

Figure 71

Transposing a

column into a row

Figure 72

Formula multiplying two cells