Mouse right click not working in Excel sheets

Please try these steps and check after each step. If these don't work, let me know. I will provide further troubleshooting steps.

1. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open Excel and see if the problem disappears or not.

Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

2. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

3. Try repairing your office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...

I have the same problem.

1. Cannot us RH mouse click to copy or cut but paste working OK
2. Also cannot copy a cell/s by grabbing the bottom RH corner and dragging.

Cleaned out the |Excel folder as in 1. above and that fixed the RH mouse click in my 1. above but still not able to copy a cell or cells by dragging the corner.

Started in Safe mode and everything works fine. Checked addins and there are no Com Add-ins loaded.

Did a quick repair and no change.

Thank you for your answer.

I have checked the files are neither protected nor shared. Even if I open a new file it is the same issue.

Can you do File > Info and see whether your workbook structure is protected?

Another possibility is that your sheets may be Grouped or Shared. In this case, Group or Share will appear on top of your worksheet.

Does it happen with all workbooks?