What does a $ in an excel formula do?
 

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.

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.


"Mandy" wrote in message
...
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.