Help with auto fill and formulae

[norwich5]

I want Excel to auto-fill formulas where the cell references increment.
For example:

I fill in the first three cells with:

=A5
=A10
=A15

Then I select them all and using the auto fill handle drag down over
the next three cells. What I want them to say is:

=A20
=A25
=A30

But what they actually say is:

=A8
=A13
=A18

Does anyone know how to remedy this?

I am using Excel 2003.

Thanks.

 

[Frank Kabel]

Hi
one way: enter the following formula in your first cell (e.g. in cell
B1):
=INDIRECT("A" & ROW()*5)
copy this down
another formula for B1 would be
=OFFSET($A$1,ROW()*5-1,0)

HTH
Frank