I have a spread sheet - row 3 is a progression from 3-20 (3,4,5....19,20)
Column C has set values starting from row 6.
E6=E4*C6
E7=E4*E4*C7
E8=E*E4*E4*C8
E8=E4*E4*E4*E4*C9

F6=F4*C6
F7=F4*F4*C7
F8=F4*F4*F4*C8
F9=F4*F4*F4*F4*C9

if I use autofill by dragging across to fill columns G onwards the C7
becomes E7 then F7 thenG7 and so on, eg G8=G4*G4*G4*E8 instead of the correct
G4*G4*G4*C8 - same problem if I drag down - E10 becomes =E8*C10 instead of
=F4*F4*F4*F4*F4*C10.

All help gratefull received as I have have to extend this table in both
directions.

OS is XP Home - excel is 2002

Many Thanks


--
When would now be a good time to change?