What does a $ in an excel formula do?

M

Mandy

What does a $ in an excel formula do?
I am using someone else's template and I don't know how to tell what it does.
 
A

Alan

Its called absolute referencing.. =$A$1 dragged down will remain as the
value in A1. =A1 dragged down will become the values in A2, A2, A3 etc. That
is to say the dollar sign 'locks' the cell reference and does not allow it
to be altered by copying, dragging and so on. Check out 'Absolute! in help,
its all there,
Regards,
Alan.
 
Top