I

P

Absolute Positioning

N

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).


I

P

Absolute Positioning

N

423373