Auto fill

**duongthaiha** · 10-08-2010, 07:25 AM

Hi

I have a cell A1= AVERAGE(D1:D100) how can i auto fill the A2 to be A2=AVERAGE(D101:D200) and A3=AVERAGE(D201:300)

Thanks a lot

**DonkeyOte** · 10-08-2010, 07:45 AM

You can use either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

the latter though shorter in syntax terms is volatile (see link in sig. for more info. if interested)

**duongthaiha** · 10-08-2010, 07:52 AM

Hi
Thanks a lot for that

Is there a way to used the auto fill step value in excel 2010?

Best regards

Originally Posted by DonkeyOte

You can use either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

the latter though shorter in syntax terms is volatile (see link in sig. for more info. if interested)

**DonkeyOte** · 10-08-2010, 07:57 AM

No - Fill Series relates to Constants.

(please don't quote entire posts in your reply - clutters your thread and board in general)

**duongthaiha** · 10-08-2010, 07:57 AM

Really appreciate your help. Its a great:D

Re: Auto fill