Microsoft Office Tutorials and References

In Depth Information

**Using mixed references**

The easiest way to understand this concept is with an example. Figure 29-1 shows a simple

worksheet. The formula in cell D2 is

=(B2*C2)*$B$7

Figure 29-1:
Formula references to the sales tax cell should be absolute.

This formula uses relative cell references (B2 * C2) and also an absolute reference to the sales tax cell

($B$7). This formula can be copied to the cells below, and all of the references will be correct. For

example, after copying the formula in cell D2, cell D3 contains this formula:

=(B3*C3)*$B$7

The references to the cells in columns B and C are adjusted, but the reference to cell B7 is not —

which is exactly what you want.

Using mixed references

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.

Here are two examples of mixed references:

=$A1

=A$1