Absolute cell referencing
how does this work?
thanks
anne
RE: absolute cell referencing
Hi Anne,
A relative cell reference in a formula, such as A1, is based on a relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed.
An absolute cell reference in a formula, such as $A$1, will always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same.
Hope that helps Tracy