Excel Left and Right Mouse Buttons Not Working?

If the left or right mouse button is not working in Excel, first check whether the same button works elsewhere; then press Esc, test a different workbook, and check your mouse’s primary-button setting. If left-clicking fails only in one sheet or right-clicking fails only in Excel, Excel may be in an editing state, the sheet may be protected, or an add-in or workbook macro may be interfering.

What the Left and Right Buttons Do in Excel

A left-click normally selects a cell, button, tab, or ribbon command. Dragging with the left button can select a range, move a cell border, or adjust a column width. A right-click usually opens a context menu with actions relevant to where the pointer is—for example, options to copy, insert, delete, or format a cell. Because the two buttons have different jobs, a failure with one does not necessarily mean the other is broken.

Also distinguish a mouse-button problem from an Excel navigation problem. Arrow keys move the active-cell selection, while the mouse selects the cell under the pointer. If clicks work but arrow keys do not move the selection as expected, Scroll Lock may be on; that affects keyboard navigation, not the mouse buttons themselves. If a click selects a cell but typing replaces its contents, Excel may simply be ready for data entry.

Start With a Quick Isolation Check

Test the buttons outside Excel before changing workbook settings. Click a desktop icon or a text field with the left button, and open a context menu with the right button. If either button fails in other apps too, investigate the mouse, touchpad, Windows settings, or connection first. If both work elsewhere, focus on Excel or the particular workbook.

Then try these checks in Excel for Microsoft 365 on Windows:

Press Esc once or twice. This can cancel cell editing, a selection operation, or an open menu that is intercepting input.
Click a cell in a new blank workbook. Use Ctrl+N to create one, or open a separate workbook. If clicks work there, the original file is a useful clue.
Try right-clicking a blank cell and then a cell with data. A context menu may differ by location, so test more than one place.
Use Shift+F10 while a cell is selected. This opens the cell’s context menu from the keyboard and helps determine whether the issue is limited to right-click input.
Wait briefly if Excel is calculating or displaying “Not Responding.” A busy application may not respond to either button until it finishes.

On a Mac, Control-click or a configured secondary click can open a context menu. In Excel for the web, test another browser tab or a desktop app if available; a browser extension or browser-level issue can affect web input without affecting desktop Excel.

Check Whether Excel Is Waiting for an Action

Excel can behave as though a click has stopped working when it is waiting for the current action to finish. If a cell is being edited, clicking another cell may not behave like ordinary selection. Press Esc to cancel the edit, or Enter to commit it, and then try again. A dialog box can also block interaction with the worksheet; look for a message window behind the workbook or use Esc if the dialog allows it to close.

Another possibility is that a drag operation or selection is still active. Press Esc, release both mouse buttons, and click once rather than dragging. If the pointer is over the formula bar, a chart, a shape, or a ribbon control, Excel may respond differently than it does over a worksheet cell. Test in the middle of an ordinary, unmerged cell to remove those variables.

Do not assume that frozen panes or a hidden row make the mouse defective. Freeze Panes changes which rows or columns remain visible while scrolling; it does not normally disable clicking. Hidden or very narrow rows and columns can make a target difficult to select, so try the Name Box to move to a known cell, or use the sheet tabs to test a different sheet.

Inspect Windows Mouse and Touchpad Settings

Windows allows the primary mouse button to be switched. If the buttons seem reversed—right-click behaves like selection and left-click opens menus—check this before troubleshooting Excel. In Windows 11, open Settings > Bluetooth & devices > Mouse and review Primary mouse button. In Windows 10, open Settings > Devices > Mouse and review Select your primary button. Choose Left if you want the conventional arrangement.

For a wireless mouse, check its power switch, battery, receiver, and Bluetooth connection. For a wired mouse, reconnect it and try a different USB port. If you use a laptop touchpad, make sure tapping or physical clicking is enabled and check whether an external mouse is changing how the touchpad behaves. Restarting the computer can clear a temporary input-device or driver problem.

If the issue persists across applications, consult the mouse or computer maker’s support instructions for driver updates. Avoid installing driver utilities from unfamiliar download sites. On a Mac, check System Settings > Mouse for the secondary-click option; trackpad settings are under System Settings > Trackpad. The precise labels can vary by macOS release and device.

Check Sheet Protection and Workbook-Specific Behavior

Worksheet protection can restrict what users may select or change. A protected sheet may allow selection of unlocked cells but not locked cells, depending on the protection options chosen by the workbook’s author. That can look like a left-click failure when only certain cells are affected. Check whether the Review tab shows Unprotect Sheet. If it does, the sheet is protected; unprotect it only if you are authorized and have any required password.

Protection does not usually disable every mouse action, and it is not a reason to try to bypass a password. Compare a locked-looking cell with an unlocked area, or test another sheet. If only one workbook has the problem, the file may also contain macros or customizations that alter Excel’s menus or input behavior. Close it and check whether a fresh workbook behaves normally.

A workbook macro can change Excel’s context menus, and custom code or an add-in can affect commands. If right-clicking fails only in one file, reopen the file without enabling content if Excel presents a security prompt, provided doing so is appropriate for your work. Do not enable macros in a file from an untrusted source just to restore a menu. Ask the file’s owner or your organization’s administrator if the workbook is managed.

Test Excel Add-Ins and Startup Problems

If mouse clicks fail in several workbooks but work normally in other applications, test whether an add-in or Excel customization is involved. On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain startup features and add-ins disabled. Open a workbook and test the same clicks.

If the problem disappears in Safe Mode, an add-in or customization is a reasonable suspect, though the test does not identify which one. In normal Excel, go to File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins or Excel Add-ins, choose Go, and temporarily clear an add-in’s checkbox. Restart Excel and test again. Re-enable items one at a time to identify a change, and check with your organization before disabling a work-required add-in.

If Safe Mode makes no difference, it does not prove Excel itself is damaged. The cause could still be a workbook, Windows input setting, device driver, or another running utility. Save your work, close Excel fully, restart Windows, and test a new workbook before considering repair or reinstalling Office. If this is a managed computer, involve IT before changing installation settings.

Excel for the Web and Mac Differences

Excel for the web runs inside a browser, so a failure there is not automatically an Office desktop problem. Reload the page after saving changes, try a private or InPrivate window, and check whether browser extensions are affecting the page. If the worksheet works in the desktop app but not in the browser, report the issue through the browser or Microsoft 365 support route used by your organization. Be cautious with unsaved edits before refreshing.

On Mac, test the mouse in another app, check System Settings for primary and secondary click behavior, and try Control-click for a context menu. Menu names and settings can vary across macOS versions. Excel for Mac also has different system integration from Windows, so Windows Safe Mode steps and Windows mouse-setting paths do not apply. If only one workbook is affected, compare it with a new workbook on the Mac as well.

For either platform, a keyboard route is a practical temporary alternative: select a cell with the arrow keys and press Shift+F10 on Windows to request its context menu. On Mac, Control-click is the usual equivalent for a secondary click. These workarounds can help you continue, but they do not fix a failed physical button or explain why the pointer is not being detected.

When to Repair, Replace, or Ask for Help

Use the scope of the failure to choose the next step. A button that fails everywhere points toward the mouse, touchpad, operating-system setting, or connection. A button that fails only in Excel suggests an Excel state, add-in, or customization. A problem limited to one workbook suggests protection, workbook-specific code, or file-specific behavior. Recording exactly where it happens makes support requests much easier to resolve.

If a different mouse works, inspect or replace the original mouse rather than changing workbook settings.
If only one file is affected, test a copy or a new workbook and ask the file owner about protection and macros.
If Excel behaves normally in Safe Mode, review add-ins and startup customizations selectively.
If the issue persists across workbooks and Safe Mode, restart Windows and contact your IT team or Microsoft support before attempting an Office repair.

Before repairing Office or changing a business-managed setup, save and close open files and follow your organization’s support process. Repair options and labels may differ by Office installation type and Windows version, so use Microsoft’s current support guidance rather than an unrelated registry or macro fix.

Frequently Asked Questions

Why does right-click not work in Excel but work elsewhere?
Excel may be busy, a workbook macro or add-in may have changed the context menu, or the issue may be limited to a protected or customized workbook. Test a blank workbook and press Shift+F10 with a cell selected to open the context menu from the keyboard.

Why does my left mouse button select the wrong cells?
Check whether a drag is still active, whether the pointer is over a merged cell or object, and whether the primary mouse button is set as intended in Windows. If only certain cells cannot be selected, check sheet protection and try another sheet.

Can worksheet protection stop me from clicking cells?
It can restrict selection of locked or unlocked cells according to the protection options, so some cells may not be selectable. It generally does not explain a mouse button failing everywhere. Check the Review tab and ask the workbook owner if you lack permission to change protection.

How do I right-click in Excel without a mouse?
Select a cell and press Shift+F10 on Windows to open its context menu. On a Mac, Control-click is the usual secondary-click method; trackpad or mouse settings can also configure a secondary click.

Why do mouse clicks work in Excel Safe Mode?
Safe Mode disables certain startup components, so an add-in or customization may be involved. Return to normal mode and disable add-ins one at a time through File > Options > Add-ins, testing Excel after each change.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.