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,

How would excel know in what part of the formula you wanted the absolutes.
try using the f4 key to put in your absolutes

--
Don Guillett
SalesAid Software

"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,

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,