Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

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

  • yellow-01.jpg Click a cell where you want to enter a formula.
  • yellow-02.jpg Type = (an equal sign) to begin the formula.
  • yellow-03.jpg Select a cell, and then type an arithmetic operator (+, -, *, or /).
  • yellow-04.jpg Select another cell, and then press the F4 key to make that cell reference absolute.
  • You can continue to press F4 to have Excel cycle through the different reference types.
  • yellow-05.jpg If necessary, continue entering the formula.
  • yellow-06.jpg Click the Enter button on the formula bar, or press Enter.
  • + Share This
  • 🔖 Save To Your Account