|
Yep, a $ sign before the row or column designator will make that part an absolute reference. This is especially useful if you'll be using fill operations to replicate the formula but need part of the forumula to remain fixed by row, column, or both.
a1 vs $a1 vs a$1 vs $a$1
You may want to look into addressing by name to simplify your formulas.
|