| Type | Example | When copied |
|---|---|---|
| Relative | B2 | Both column and row shift with the copy |
| Absolute | $B$2 | Neither changes |
| Mixed | $B2 or B$2 | Only the part without the dollar sign changes |
A dollar sign locks what follows it: column, row, or both.
- 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.