Absolute Functions

[CLT]

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,

[Don Guillett]

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
[email protected]
"CLT" <[email protected]> wrote in message
news:[email protected]...
> 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,

[Ragdyer]

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" <[email protected]> wrote in message
news:[email protected]...
> 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,