Formula auto-fill help!!

Guys,

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

Thanks.

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