Using Absolute Cell References

Using Absolute Cell References

graphics/microsoft45.gif

When you want a formula to consistently refer to a particular cell, even if you copy or move the formula elsewhere on the worksheet, you need to use an absolute cell reference. An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference. If you want part of a formula to remain a relative reference, remove the dollar sign that appears before the column letter or row number.

Use an Absolute Reference

graphics/one_icon.jpg

Click a cell where you want to enter a formula.

graphics/two_icon.jpg

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

graphics/three_icon.jpg

Select a cell, and then type an arithmetic operator (+, -, *, or /).

graphics/four_icon.jpg

Select another cell, and then press the F4 key to make that cell reference absolute.

graphics/five_icon.jpg

If necessary, continue entering the formula.

graphics/six_icon.jpg

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

graphics/08inf09.jpg

Did You Know?

You can change an absolute reference back to a relative reference . In the cell with the absolute formula, press F4 repeatedly until all the dollar signs are removed from the reference.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net