Office Settings & Configuration

How to Disable Drag and Drop for One Excel Workbook or Worksheet

Guest Writer Oct 12, 2026 869 views

Question details

The user needs to disable the drag-and-drop editing feature specifically for a single Excel workbook or worksheet, rather than globally across the entire Excel application.

How to Disable Drag and Drop for One Excel Workbook or Worksheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Preventing accidental data movement or formatting changes in a protected or specific worksheet while retaining the feature for other files.
Observed behavior: Excel's standard options only allow disabling drag-and-drop editing for the entire application, which affects all open workbooks simultaneously.

Before you start

Before modifying settings, note that Excel's built-in toggle will affect all your open workbooks. For a workbook-specific solution, you will need to use VBA macros, so ensure the Developer tab is enabled in your ribbon.

Solution 1Recommended

Disable Drag and Drop Globally via Excel Options

Use Excel's built-in settings to quickly turn off drag-and-drop editing. Note that this affects all open workbooks in the application.

Open Excel Options

Click on the 'File' tab in the top-left corner of the ribbon and select 'Options' at the bottom of the menu.

Navigate to Advanced Settings

In the Excel Options dialog box, click on 'Advanced' in the left-hand navigation pane.

Disable the Feature

Under the 'Editing options' section, uncheck the box labeled 'Enable fill handle and cell drag-and-drop'.

Apply Changes

Click 'OK' to save the settings. You will no longer be able to drag and drop cells in any open workbook.

Disable Drag and Drop Globally via Excel Options

Solution 2

Use VBA to Disable Drag and Drop for a Single Workbook

Apply VBA code to restrict the drag-and-drop functionality only when a specific workbook is active.

Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience

If you frequently encounter limitations with Microsoft Office configurations, consider switching to WPS Office. It provides a robust, lightweight, and highly compatible alternative with excellent data management tools—all for free.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Install the Suite: Run the installation file and follow the on-screen prompts to set up WPS Office on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly with full formatting and formula support.

Completely free and lightweight office suiteSeamless compatibility with Microsoft Excel formats (.xlsx, .xlsm, .xls)Familiar user interface requiring zero learning curveBuilt-in tabbed viewing for easier workbook management

microsoft office alternative - wps office

Frequently Asked Questions

Can I disable the fill handle but keep drag and drop active?

No, Excel controls both the fill handle and the cell drag-and-drop features with a single unified setting. Disabling one will automatically disable the other.

Why can't I drag and drop cells in any of my Excel files?

Your global setting for this feature has likely been disabled. To turn it back on, go to File > Options > Advanced, and ensure that the 'Enable fill handle and cell drag-and-drop' option is checked.

Will the VBA method affect other users who open my workbook?

Yes, provided the other users enable macros when opening the file. The VBA script will temporarily turn off the drag-and-drop application setting for them while your workbook is active, and restore it when they switch to another file.

Office App Problems