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

 

Excel Drag and Drop

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.

Enable Cell Drag and Drop Option in Ms Excel 2007

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

That’s it :)

Subscribe to receive more Adsense, SEO,Blog Hacks articles to your Inbox

Share this Post:
Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

No Responses to “How to Enable or Disable Cell Drag and Drop Editing Option in Ms Excel?”

Leave a Reply:

Name (required):
Mail (will not be published) (required):
Website:
Comment (required):
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv badge