xxxxxxxxxx
$A$1
absolute reference to column A and row 1 (rows and columns won't change when copied)
xxxxxxxxxx
By default, address is relative: A1
Use a $ before column or row address to keep them absolute:
- Keep column absolute, but row relative: $A1
- Keep column relative, but row absolute: A$1
- Keep column absolute and row absolute: $A$1