You are here: Home/How To/ How to Enable or Disable Cell Drag and Drop Editing Option in Ms Excel?

How to Enable or Disable Cell Drag and Drop Editing Option in Ms Excel?

By: Praveen, Last Updated: August 5, 2012

Problem: In Microsoft Excel the cell drag and drop is missing. How to enable it?

Solution: The cell drag-and-drop feature allows you to click a cell, hold the mouse button, drag the cell to another location on the spreadsheet and drop it. For some users this is an indispensable feature, but for others it’s an inconvenience that they can do without. In this post lets see how to enable or disable this excel feature.

Steps to Enable/Disable Drag & Drop Option in MS Excel:

Click the Office Button. A menu will appear.

Click Excel Options.

Click the Advanced tab.

Under Editing Options, make sure that “Enable fill handle and cell drag-and-drop” is checked.