View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default autofill using mouse is not working in excel 2001

wrote in message
oups.com...
I hope that someone can help me with this problem, it just started up
today and I have done all the searching on the internet that I could
but cannot solve the problem.

Description:
Excel today just stopped showing the "+" cursor that usually comes up
when you have highlighted a set of cells and allows you to pull down
to fill a series or generally autofill based on the contents of the
cell.
I can still do the autofill by going to the menu item and selectign
the correct option for it, but the quick way does not work anymore.
I am using office xp with windows XP +SP2+ all recent patches.

Any ideas anyone, would appreciate any help in this matter as I use
autofill (with the mouse) quiet a lot.

Thanks
chandrasekhar


Check he
Tools Options Edit tab
"Allow cell drag and drop" should be ticked.
Does this solve the problem?