Reference types
TypeExampleWhen copied
RelativeB2Both column and row shift with the copy
Absolute$B$2Neither changes
Mixed$B2 or B$2Only the part without the dollar sign changes

A dollar sign locks what follows it: column, row, or both.

— Rule to remember
  • Relative shifts, absolute is fixed, mixed locks one part.
  • Lock a constant such as a rate with $.
  • Shift each unlocked part by the distance moved.