Try this:

From the Excel main menu:
<tools<options<edit tab
Make sure "Allow cell drag and drop" is CHECKED

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Danny Lewis" wrote:

Hi All

For some reason my excel 2000 won't let me autofill

ie the bottom right corner of each cell doesnt have the black dot which i
can click on and drag formulae

Anyone know how I can set this to work?
Thanks