MS+Excel++Disable+Fill+Handles+and+Drag-Drop+Abilities

MS Excel Disable Fill Handles and Drag-Drop Abilities Many people find those features to be more of a pain than they are worth. If this is your opinion of the situation then disabling the fill handle along with the drag and drop abilities might be the way for you to go. It probably never even occurred to some of you that they could be disabled but they can and with just a few clicks, you can prevent the issues they seem to create for you. File tab / Office Button and then click Options. Once in the Options dialog box we need to navigate on the left side to the Advanced category.

On the in the Editing options section, locate the:- “Enable fill handle and drag-and-drop“ option. Un-tick/check the box. Click OK.

That is it