Tuesday, February 12, 2013

How to Disable Cell Drag in Excel


1. Open Excel and click the 'File' menu tab in the top-left corner of the screen.
2. Click 'Options' on the bottom-left of the menu to open the Excel Options window.
3. Click 'Advanced' in the left window pane.
4. Click the box next to 'Enable Fill Handle and Cell Drag-and-Drop' to clear the check mark.
5. Click 'OK' to close the window and save the changes.

Blogger news