Following video demonstrates nice and easy way to quickly change cell reference type between absolute and relative reference:
- Select Formulas tab in Ribbon bar
- Select reference in formula
- Click Switch Reference to change reference type A1 –> $A$1 –> A$1 –> $A1
See my earlier posting about Absolute and Relative References.