Using Absolute Cell References

Using Absolute Cell References

graphics/microsoft08.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/tow_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/foure_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/03inf08.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 Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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