Microsoft KB Archive/820204

= How to change from absolute to relative or mixed references in a formula in Excel =

Article ID: 820204

Article Last Modified on 2/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



SUMMARY
In Excel, you can create absolute, relative, or mixed references in a formula. You can easily change from one reference type to another without having to retype it by pressing F4.



MORE INFORMATION
The following is a description of different reference types.

To toggle from one reference type to another:
 * 1) Select the cell that contains the reference you want to change.
 * 2) In the formula bar, select the reference or references that you want to change.

Select the whole formula if you want to change all the references.
 * 1) Press F4.

Each time you press F4, Excel cycles through the different types of reference in the order of the table. For example, if you type a relative reference and then press F4, the reference changes to absolute. When you press F4 again, the reference changes to mixed with the row fixed.

