How do I initiate/use an absolute reference?

Hi Scott,

You use an absolute reference if you want to fix one particular cell in a formula. It means when you use the Autofill the absolute reference stays fixed, where the other cell references move depending on where you drag your cursor.

To change a reference you can simply click into the reference and press the F4 button or you can manually type in dollar signs, for example A1 becomes $A$1.

Good luck

Tracy