Excel for Marketing Managers

Multiplication Tables

Multiplication
Tables
If you change C1 to $C$1, it is called an Absolute reference. When you copy a
formula with this reference, the formula will always point to cell C1. The dollar
signs ($) before C and 1 ensure that neither the C nor the 1 will change as the
formula is copied to other cells.

Sometimes, you need a reference that is partially absolute. This is called a

Mixed reference and has only a single dollar sign.

If you place the dollar sign before the column letter, then the column letter will

be fixed but the row number will change as you copy the formula down the

rows. In our current example, the portion of the formula pointing at column A

would need a dollar sign before the A.

If you place the dollar sign before the row number, then the row number will be

fixed, but the column letter will change as you copy the formula across a range.

In our current example, the portion of the formula pointing at row 1 would

need a dollar sign before the 1.

1. Select the range.
   Move the cellpointer to cell B2. While holding down the Shift key, use the
   Down- and Right-arrow keys to select the range of B2:M13.


2. Enter the formula.
   Any formula that you type will start to appear in cell B2. Type the following
   formula: =B$1*$A2


3. Copy the formula throughout the range.
   Then, instead of pressing Enter by itself, type Ctrl+Enter to put a similar
   formula in the entire selected range.

Figure 73

Relative references