Microsoft Office Tutorials and References

In Depth Information

**Apply Absolute and Relative Cell References**

Apply Absolute and Relative Cell References

By default, Excel uses relative cell referencing. If you copy a formula containing a relative cell

reference to a new location, Excel adjusts the cell addresses in that formula to refer to the cells

at the formula’s new location. For example, if you enter, in cell B8, the formula =B5+B6 and then you

copy that formula to cell C8, Excel adjusts the formula to =C5+C6.

When a formula must always refer to the value in a particular cell, use an absolute cell reference.

Absolute references are preceded with dollar signs. If your formula must always refer to the value in

cell D2, enter $D$2 in the formula.

Apply Absolute and Relative Cell References

Copy Relative References

1
Enter the formula.

2
Click the cell containing the

formula you want to copy.

A
In the Formula bar, the

formula appears with a

relative cell reference.

3
Click the
Home
tab.

4
Click
Copy
(

).

5
Select the cells where you

want the formula to appear.

6
Click
Paste
.

B
Excel copies the formula to

the selected cells.

C
The adjusted formula appears

in the Formula bar and in the

selected cells.

198