Absolute Functions

C

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

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
 
R

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.
 
Top