When entering formulas, use the F4 key to toggle between absolute and relative references. When typing the above example, after typing “A1”, press F4. Keep pressing F4 until the combination of absolute/relative references appears.
For a refresher on the differences between Relative and Absolute references, go to:
I Teach Accounting Information Systems 