if i want a cell reference to not increment when filling i put a
dollar sign in front of it

i noticed this does not work when you specify a range of cells eg )
$A1:$A20 although it is not an error

when i fill in a formula it still increments the cell reference in
each row but if i specify a single cell it does not.

does anyone know the syntax for this, it's hard to word so i havent
been able to find anything on google.

thanks for your help!

cheers,
/sh