$?

B

Bob Phillips

This is absolute v relative referencing.

If you put =$A1 in B1, and copy across to J1, every cell will contain =$A1.

If you put =A1 in B1, and copy across to J1, each cell will be referencing a
different cell, Excel updates each.

This is very useful when copying formula, to ensure each target cell gets
the correct formula.
 
Top