Sometimes it is necessary to keep a certain position that is not relative
to the new cell location. This is possible by inserting a $
before the Column letter or a $ before the Row number (or both).
This is called Absolute Positioning.
A
B
C
1
5
3
=$A$1+$B$1
2
8
2
=$A$1+$B$1
3
4
6
=$A$1+$B$1
4
3
8
=$A$1+$B$1
If we were to fill down with this formula we would have the exact
same formula in all of the cells C1, C2, C3, and C4. The dollar signs
Lock the cell location to a FIXED position. When it is copied and
pasted it remains EXACTLY the same (no relative).
