Microsoft Office Tutorials and References
In Depth Information
Knowing When to Use Mixed References
Knowing When to Use Mixed References
In the previous tip, I discuss absolute versus relative cell references. This tip covers an additional
type of cell reference: In a mixed cell reference, either the column part or the row part of a
reference is absolute (and therefore doesn’t change when the formula is copied and pasted). Mixed
cell references aren’t used often, but as you see in this tip, in some situations, using mixed
references makes your job much easier.
An absolute cell reference contains two dollar signs. A mixed cell reference contains, by
comparison, only one dollar sign. Here are two examples of mixed references:
=\$A1
=A\$1
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 70-1 shows a worksheet demonstrating a situation in which using mixed references is the
best choice.
Figure 70-1: Using mixed cell references.
The formulas in the table calculate the area for various lengths and widths. Here’s the formula in
cell C3:
=\$B3*C\$2

Search JabSto ::

Custom Search