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
Search JabSto ::




Custom Search