Hello Goto Tools--->Option---->Allow Cell drag and drop---->Let the Check box ticked then you can drag, drop and auto fill regards Muthu Pandian.
--- On Sat, 14/2/09, Marc <m...@marcforget.com> wrote: From: Marc <m...@marcforget.com> Subject: $$Excel-Macros$$ Fill Handle Disabled To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Saturday, 14 February, 2009, 2:47 AM Hello, For some reason in the past week or so my fill handle doesn't show up in my workbooks. I checked that my Advanced Excel Options are set to enable Fill Handle and cell drag and drop. And the little black square does appear at the bottom right of the cell, but my cursor doesn't change to a cross which would allow me to drag down. Right now my cursor remains the same when I hover over the black square. Has anyone encountered this before? I did close and restart and reboot and it still hasn't fixed it. Thanks. marc Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---