Switch between relative, absolute, and mixed references

  1. Select the cell that contains the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, select the reference that you want to change.
  3. Press F4 to switch between the reference types.

The following table summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right.

 
 
Applies to:
Excel 2007