Excel - Switch between relative, absolute, and mixed references

1. Select the sell that contains the formular;
2. In the formula bar fx, select the reference you want to change;
3. Press F4 toggle through the combinations.

Reference (Description)
$A$1 (absolute column and absolute row)
A$1 (relative column and absolute row)
$A1 (absolute column and relative row)
A1 (relative column and relative row)