How to change from absolute to relative or mixed references in a formula in Excel
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.
The following is a description of different reference types.
|Absolute||$A$1||Both the row and column are fixed|
|Mixed||A$1||Only the row is fixed|
|Mixed||$A1||Only the column is fixed|
|Relative||A1||Neither the row or column is fixed|
To toggle from one reference type to another:
Select the cell that contains the reference you want to change.
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.
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.
For more information about Referencing, click Microsoft Excel Help on the Help menu, type References in the Office Assistant or the Answer Wizard, and then click Search to view the topic.