How to Disable Excel Double-Click Border Scrolling Separately
Question details
The user wants to disable the feature where double-clicking a cell border moves the selection to the edge of the data region, without disabling the fill handle and cell drag-and-drop.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Navigating or editing data in spreadsheets where accidental double-clicks on cell borders cause unwanted scrolling or jumps.
- Observed behavior
- Excel currently links the double-click border scrolling behavior with the 'Enable fill handle and cell drag-and-drop' setting, meaning you cannot disable one without disabling the other.
Note that Microsoft Excel currently bundles the double-click border jump feature with the drag-and-drop and fill handle settings. Disabling it will turn off all these features simultaneously.
Disable Fill Handle and Cell Drag-and-Drop
You can disable the border scrolling behavior by turning off the drag-and-drop setting, though this also disables the fill handle.
Since Microsoft has not yet separated these two functionalities, the only native workaround is to disable the parent setting entirely. Keep in mind that you will need to rely on keyboard shortcuts (like Ctrl+D or Ctrl+R) to fill data instead of using your mouse.
Click on 'File' in the top-left corner of the Excel window and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on the 'Advanced' tab located on the left pane.
Under the 'Editing options' section, uncheck the box for 'Enable fill handle and cell drag-and-drop', then click 'OK' to save your changes.
Submit a Feature Request to Microsoft
Since there is no built-in way to separate these settings, submitting feedback to the Excel community is the official way to request a change.
Try WPS Office for a Streamlined Spreadsheet Experience
If you are frustrated with restrictive settings in Microsoft Excel, consider trying WPS Office. It is a free, lightweight, and highly compatible Office alternative that provides a familiar user interface and robust spreadsheet capabilities.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install and Launch: Follow the on-screen instructions to install the software, then launch WPS Spreadsheet.
- 3. Open your Excel files: Seamlessly open your existing .xlsx files without losing any formatting or data.
Frequently Asked Questions
Why does my Excel jump to the bottom of the page when I click a cell?
This happens if you accidentally double-click the bottom border of the active cell. Excel interprets this as a command to jump to the last non-empty cell in that column.
Can I turn off just the double-click border scrolling without losing the fill handle?
Currently, Microsoft Excel does not offer a standalone option to disable double-click border scrolling. It is tied to the 'Enable fill handle and cell drag-and-drop' setting.
What is the fill handle in Excel?
The fill handle is a small square at the bottom-right corner of an active cell. It allows you to quickly drag and fill formulas, numbers, or text across adjacent cells.
Will disabling drag-and-drop affect other Excel workbooks?
Yes, unchecking 'Enable fill handle and cell drag-and-drop' in Excel Options is an application-level setting, meaning it applies to all workbooks you open in Excel.
