select the cell, F2, select the formula, then F4. each successive F4 toggles
between the absolute/relative combinations.

--
HTH

Bob Phillips

"Bridgerider" wrote in message
...
Does anyone know a quick was to add dollar signs to cell refferences on a
worksheet so that the refferences remain fixed?