This is an odd one. I fired up Excel yesterday, went to drag a cell to copy some figures only to find the fill handle was missing from the bottom right corner of the cell.
Have I somehow switched off this function?
I've tried closing the application and re-opening, switching the machine off and on again both to no avail. Any ideas??
Tools > Options > Edit > Allow cell drag and drop
Allow cell drag and drop Select the Allow cell drag and drop check box to move and copy cells and data by dragging. With this option selected, you can also drag the fill handle to copy data and to fill adjacent cells with a series of data.
Thank you so much!
Re: Fill handle has disappeared
Do you know how to turn it back on for Excel 2010? I'm having the same issue, but do not have the same tools location as Excel 2003, and I have not found everything yet. I've searched YouTube and Google and am coming up empty handed...
Ctifftiff,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks