Microsoft Office Tutorials and References
In Depth Information
Using Absolute Cell References
Using Absolute Cell References
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.
Create an Absolute Reference
Click a cell where you want to enter a formula.
Type = (an equal sign) to begin the formula.
Select a cell, and then type an arithmetic operator (+, -, *, or /).
Select another cell, and then press the F4 key to make that cell reference abso-
lute.
You can continue to press F4 to have Excel cycle through the different referen-
ce types.
If necessary, continue entering the formula.
Click the Enter button on the formula bar, or press Enter.
Search JabSto ::




Custom Search