Microsoft Office Tutorials and References

In Depth Information

**Using Mixed Cell References**

Did You Know?

You can change an absolute reference back to a relative reference.
In

the cell with the absolute formula, repeatedly press F4 until all the dol-

lar signs are removed from the reference. You press F4 to cycle through

all the reference types. For example, if you enter A1 to start a formula,

press F4 to display $A$1. Press again to display A$1. Press again to

display $A1. Press it again to display A1.

Using Mixed Cell References

A mixed cell reference is either an absolute column and relative row or absolute row

and relative column. When you add the $ before the column letter you create an absolute

column or before the row number you create an absolute row. For example, $A1 is abso-

lute for column A and relative for row 1, and A$1 is absolute for row 1 and relative for

column A. If you copy or fill the formula across rows or down columns, the relative ref-

erences adjust, and the absolute ones donâ€™t adjust.

Create a Mixed Reference

Click a cell where you want to enter a formula.

Type = (an equal sign) to begin the formula.

Select the cells you want to use and then complete the formula.

Click the insertion point in the formula bar, and then type $ before the column

or row you want to make absolute.

Click the
Enter
button on the formula bar, or press Enter.