Select the cell address in the formula bar, and then hit <F4.

Select the *entire* formula in the formula bar to change *all* the cell
references in the formula at one time.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CLT" wrote in message
...
Is there an easy way to type in an absolute function so that you only have
to
type it in the formula once instead of putting $ signs throughout a long
formula.

Thanks,