No matter where you drag or copy $A$1 it will not change the reference. The $
holds the character beside it static, since there is not one by the 1 in $A1
then when you copy or move around it will Stay A but the 1 will change. Also
putting a A$1 will allow the column to change, but it will always reference
row 1.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"DOUG ECKERT" wrote:

What is the difference between the absolute cell reference format "$A$1" and
a cell reference formatted as "$A1"?