How to Fix Excel Entering Edit Mode with a Single Click
Question details
The user experiences an issue where a single click on a cell in Excel opens edit mode instead of simply selecting the cell.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Selecting and modifying cells in an Excel spreadsheet.
- Observed behavior
- A single click intermittently or consistently triggers cell edit mode, a function normally reserved for a double-click or the F2 key.
Verify that your mouse hardware is not malfunctioning and unintentionally registering a single click as a double-click. You can easily test this by single-clicking icons or folders on your computer desktop to see if they open automatically.
Disable Interfering Macros and Add-ins
Certain VBA macros or third-party add-ins can override default behaviors and force Excel into edit mode upon a single click.
If a specific workbook has a 'Worksheet_SelectionChange' event programmed into its VBA module, it might automatically send an F2 command whenever a cell is clicked. Third-party COM add-ins can also create similar conflicts.
Hold the 'Ctrl' key while clicking the Excel shortcut to open it in Safe Mode. If the single-click issue stops, an add-in or startup macro is the root cause.
Navigate to 'File' > 'Options' > 'Add-ins'. At the bottom of the window, change the Manage dropdown to 'COM Add-ins' and click 'Go'. Uncheck all add-ins and click 'OK' to see if normal cell selection is restored.
Press 'Alt + F11' to open the VBA Editor. Check the sheet modules in the Project Explorer for any 'SelectionChange' macros containing commands like 'SendKeys "{F2}"' and disable them.
Perform a Microsoft Office Online Repair
If the single-click editing issue happens across all blank workbooks and isn't caused by your mouse hardware, your Office installation files may be corrupted.
Switch to WPS Office to Avoid Constant Repair Issues
If Microsoft Excel continues to frustrate you with bugs like unintended cell editing and requires frequent repairs, consider switching to WPS Office. It provides a highly compatible, stable alternative that requires fewer system resources.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
- 2. Install WPS Office: Run the installer and follow the quick setup wizard to equip your PC with WPS Spreadsheet, Writer, and Presentation.
- 3. Open Your Spreadsheets: Right-click your existing .xlsx files and choose to open them with WPS Office to enjoy a seamless, bug-free editing experience.

Frequently Asked Questions
Why does my mouse double-click when I only click once?
This is often a hardware issue caused by worn-out microswitches inside the mouse. You can test this by plugging in a different mouse. Alternatively, you can try adjusting the double-click sensitivity by going to Windows Settings > Devices > Mouse > Additional mouse options, and lowering the Double-click speed.
How do I turn off double-click to edit in Excel?
If you want to disable editing directly within cells entirely, open Excel and go to File > Options > Advanced. Under the 'Editing options' section, uncheck the box that says 'Allow editing directly in cells'. After doing this, you will need to use the formula bar at the top to modify cell contents.
Can an Excel add-in change how my mouse clicks work?
Yes. Certain third-party add-ins, especially those designed for data entry automation or specialized reporting, can override default mouse behaviors. Launching Excel in Safe Mode temporarily disables these add-ins, allowing you to check if they are the source of the issue.





