Using Cell References in AutoFill: Relative, Absolute, and Mixed
Let's learn how Excel handles relative, absolute, and mixed references in AutoFill: I'll explain the difference between $A$1, A$1, and $A1 with practical examples, so your formulas adapt correctly when copied to other cells.