The $ sign indicates the when filling either vertically or horizintally,
that the index immediately after the sign (either a letter or number) will
not change. This is useful when each cell in a column for instance, needs
to use the one cell only to multiply by. For instance in "2" is the value
of cell A1, and in A2 thru A10 contains other values, and B2 contains the
formula " A2*A$1", and this cell is filled down to cell B10, then cell B10
will show the value (A10*A1). Without the "$" sign, the value of B10 will
show the value of (A10*A9)
Don
_1143599101.0566@excelforum-nospam.com...
> What does the $ mean in the cell reference?
Nice explanation to be found here
http://cpearson.com/excel/relative.htm

Signature
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
> What does the $ mean in the cell reference?