Formula auto-fill help!!

D

daveycmc

Guys,

How do you autofill formula containing absolute references and get the
numbers to increase sequentially for every new box copied to?

Thanks.
 
P

Pete_UK

If you have something like this:

=somefunction($A$1...)

you could change it to this:

=somefunction($A1...)

That way the row numbers will change when you copy down, but the column
reference will not change when you copy across.

Hope this helps.

Pete
 
Top