Microsoft Office Tutorials and References
In Depth Information
Using mixed references
In the first example, the column part of the reference (A) is absolute, and the row part (1) is relative. In
the second example, the column part of the reference is relative, and the row part is absolute.
Figure 29-2 shows a worksheet demonstrating a situation in which using mixed references is the best
Figure 29-2: Using mixed cell references.
The formulas in the table calculate the area for various lengths and widths of a rectangle. Here’s the
formula in cell C3:
Notice that both cell references are mixed. The reference to cell B3 uses an absolute reference for the
column ($B), and the reference to cell C2 uses an absolute reference for the row ($2). As a result, this
formula can be copied down and across, and the calculations are correct. For example, the formula in
cell F7 is
If C3 used either absolute or relative references, copying the formula would produce incorrect