|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.
- Press F4.
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.