$?

[Jim]

what is the significance of $A1 and A$1?
pls explain with example

 

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

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/relative.htm