ABSOLUTE
POSITIONING.
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).
No comments:
Post a Comment