Sometime back while working on excel 2010, it seems by mistake I disabled the option to use “cell drag and drop”. This feature allows you to drag the mouse and copy cells. If this option is disabled, your mouse pointer will never change to move pointer on selecting a particular cell.

Ok, here is what I mean. In the illustration shown below, mouse pointer is getting changed to move pointer as soon as I bring it to the edge of a cell.

excel2010

There is some info available on the net for Excel 2003 and the earlier versions ie  by going to Tools > Options > Edit and checking “Allow cell drag and drop”, you can enable this option but there is no information regarding the same for Excel 2007 and Excel 2010. So how can you enable this option in 2010?

  1. Go to File > Options > Advanced > Enable file handle and cell drag-and-drop
  2. Check this box.
  3. Click OK and you’re done

I wish there was some “mapping file” available from Microsoft for mapping excel 2003 and earlier versions navigation to excel 2007/2010. It could save us a lot of time.

Share This Article: