Absolute Functions
 

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,

Absolute Functions
 

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,

Absolute Functions
 

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,