If the mouse right-click is not working in Excel, you need to use the options offered in this text. The right-click context menu is used for varied features, together with copying and pasting knowledge, locking and unlocking the cells or sheets, inserting and formatting cells, creating hyperlinks, and many others. When the mouse right-click stops working in Excel, it creates issues for customers as a result of it impacts their productiveness.
Why can’t I right-click in Excel?
If the right-click is not working in Excel, there may be some add-in(s) accountable for the issue. You may test this by opening Excel in Secure Mode. Along with this, the XLB file of Excel may need been corrupted. The XLB file accommodates Excel settings and configurations. Corruption in this file causes issues.
Mouse right click is not working in Excel
Often, when the mouse right-click does not work on Home windows, you may strive fixes, like updating or reinstalling the mouse drivers, Checking add-ins, operating the {hardware} and Units Troubleshooter, restarting Home windows Explorer, repairing system picture information, and many others. However right here, it is an Excel-specific problem. Therefore, you must use some further fixes to resolve the issue. The next options will certainly show you how to in case your mouse right-click is not working in Excel.
First, shut Excel and restart your laptop. Now, open Microsoft Excel and see if the issue persists. In some circumstances, restarting the pc fixes most points. We additionally recommend you test for Workplace updates manually. Set up the updates (if obtainable). If this does not work, proceed forward and use the next fixes.
- Transfer the XLB file to a different location
- Open Excel in Secure Mode
- Run a VBA script in Excel
- Troubleshoot in a Clear Boot state
- Delete the Choices folder from the Registry
- Restore Workplace
Let’s see all these fixes in element.
1] Transfer the XLB file to a different location
XLB is an Excel file that shops Excel settings and different configuration info. This file is situated in your C drive, offered Microsoft Workplace is put in on that drive. If the configuration of Excel will get corrupted, you could expertise a number of points in Excel like one. An answer to such sorts of Excel issues is to delete the XLB file.
Deleting the XLB file is fully secure. Additionally, you’ll not lose your knowledge and different info in Excel after performing this motion. If you delete this file, Excel will recreate it once you open Excel. Nevertheless, we advocate you progress this file to a different location as an alternative of deleting it with the intention to get better it once more if any downside happens.
Go to the trail talked about under:
C:UsersUsernameAppDataRoamingMicrosoftExcel
Within the above path, exchange the Username together with your consumer title. After reaching the above path, you will note the XLB file there. The simplest option to go to the above path is through the Run command. Open the Run command field by urgent the Win + R keys and kind the next command. After that, hit Enter.
%appdatapercentMicrosoftExcel
The above command will immediately take you to the situation the place the XLB file is situated. Now, transfer the XLB file from there to a different location through the use of the Lower and Paste technique.
2] Open Excel in Secure Mode
Shifting the XLB file to a different location fixes the problem in most circumstances. But when the above repair does not work, the reason for the issue may be an put in add-in. Microsoft Workplace functions present customers with the power to put in further add-ins to make their work simpler. Generally, these add-ins trigger issues with Workplace functions. This may be the case with you. To test this, shut Excel and launch it in Secure Mode.
If the issue disappears in Secure Mode, because of this the problem is occurring as a result of an add-in. On this case, you must determine the problematic add-in. To take action, exit Excel Secure Mode and open it in regular mode. Now, begin disabling the add-ins one after the other and test the standing of the problem after you disable every add-in. This course of will take time however it is possible for you to to determine the problematic add-in in Excel. As soon as you discover the problematic add-in, take away it and discover its different.
The next steps will information you on find out how to disable add-in in Excel.
- Open Excel.
- Create a clean doc or open an present one.
- Go to “File > Options.”
- Choose Add-Ins from the left aspect.
- Choose COM Add-ins in the Handle drop-down on the right aspect.
- Click Go.
- Uncheck the add-in that you simply wish to disable and click OK.
3] Run a VBA script in Excel
If the right-click is nonetheless not working in Excel, run a VBA script in Excel. This technique has fastened the problem of many customers. Therefore, you must also do this. To take action, the Developer tab should be enabled in Excel. In case you do not see the Developer tab on the ribbon, allow it first.
Now, go to the Developer tab and choose Visible Fundamental. This may open the Visible Fundamental editor in Excel. Within the Visible Fundamental window, click beneath the Speedy part obtainable on the backside. In case you do not see it, press the Ctrl + G keys. Kind the next script and hit Enter.
Shut the Visible Fundamental Editor window and your downside ought to get fastened.
4] Troubleshoot in a Clear Boot state
After we begin our laptop, a lot of providers additionally begin routinely and hold operating in the background. These Providers embody Microsoft and different third-party providers. Microsoft Providers are essential for the correct functioning of a Home windows laptop. Therefore, disabling these providers could make your system unstable.
Generally, third-party background apps and providers battle with different functions and stop them from working correctly. This may be the case with you. To test this, begin your laptop in a Clear Boot state. Clear Boot is a troubleshooting state the place all of the third-party providers and startup apps stay disabled.
Launch Excel in the Clear Boot state and see if the issue persists. If not, a third-party service or background app is accountable for the problem.
Troubleshoot in the Clear Boot state to determine the offender. To take action, allow all of the background apps and restart your laptop. After restarting your system, launch Excel and see if right-click works. If sure, one of many background apps is the offender. Now, disable the startup apps one after the other through the Activity Supervisor and restart your laptop after disabling every background app. After restarting the pc, open Excel and test the standing of the problem.
Observe the identical steps to determine the problematic third-party service. However this time, you must use the MSConfig app as an alternative of the Activity Supervisor. As soon as, you discover the problematic third-party service, disable it completely through the use of the Providers Supervisor.
Associated: Can’t sort numbers or enter knowledge into Excel cell.
5] Delete the Choices folder from the Registry
This resolution requires modifications in Home windows Registry. Home windows Registry is a hierarchical database of the Home windows working system. Subsequently, you have to be cautious whereas modifying it as any mistake can result in severe errors. We advocate you create a System Restore Level and backup your Registry earlier than performing the steps written under.
Press the Win + R keys to open the Run command field. When the Run command field seems, sort regedit and click OK. Click Sure in the UAC immediate. This may launch the Registry Editor.
Copy the next path and paste it into the tackle bar of the Registry Editor. After that, press Enter.
ComputerHKEY_CURRENT_USERSoftwareMicrosoftOffice
Broaden the Workplace folder after which develop the folder that represents your Workplace model quantity. In my case, it is folder 16.0. It ought to comprise the folders of all Workplace functions. Broaden the Excel folder.
Now, right-click on the Choices folder and choose Delete. Earlier than you delete the Choices folded, be sure that it is situated contained in the Excel folder.
6] Restore Workplace
If not one of the above options labored, repairing Workplace will assist. First, strive Fast Restore. If it does not work, run an On-line Restore. On-line Restore will take extra time than Fast Restore however it is more practical than Fast Restore.
I hope this helps.
Learn subsequent: Can’t create Record in Excel: The file does not exist.
