Saturday, October 16, 2010

Excel Cell Drag Disabled / Not Working - Solution


8:34 PM |

It's very frustrating situation when you try to drag any excel cell and want that it should function iteratively. Excel problem is i was unable to drag cell corner to auto increment column. I was working with excel 2007 and noticed that i am not able to Drag Cell I think it was like Disabled / Not Working, after trying with some excel options finaly i got the solution for Excel Cell Drag Disabled or Why not not working.


Excel Cell Drag Disabled / Not Working - Solution

This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. Note In Microsoft Office Excel 2007, this problem may occur when the Enable fill handle and cell drag-and-drop check box is cleared. To locate the Enable fill handle and cell drag-and-drop check box, click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.


To work around this problem in Microsoft Excel 2000, in Microsoft Excel 2002, and in Microsoft Office Excel 2003, follow these steps:

1. On the Tools menu, click Options.
2. On the Edit tab, click to select the Allow cell drag and drop check box, and then click OK.

To work around this problem in Excel 2007, follow these steps:

1. Click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.


2. Click to select the Enable fill handle and cell drag-and-drop check box, and then click OK.

- If you are using MS-Office 2010 then see below screen to resolve your issue:

Leave A Comment