This is the position of a Cell that when a formula using it is copied will always refer to that Cell.
To make an Absolute Reference to a Cell use the $ symbol before the Row or Column name.
For example when copied:
– $B$4 will always reference Cell B4
– B4 will change whenever it is copied. If you copy one Row down and one Column across the B will change to a C and 4 will change to a 5
– $B4 will only change the Row. If you copy one Row down and one Column across the B will stay as B and 4 will change to a 5
– B$4 will only change the Row. If you copy one Row down and one Column across the B will change to a C and 4 will stay as a 4
