This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In any spreadsheet now the right click no longer opens the menu. I can't copy and paste, edit or anything else. The mouse works in word and other applications, and in fact works in the header or menus of excel. But if I got to a cell, it will not open upon right click.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Try this:
From your worksheet, press Alt + F11. careful, that's ALT + F11
Next press Ctrl+G
Type in (or copy here and paste)
Application.CommandBars("Cell").Reset
Then press the Enter key.
Press Alt+Q to return to the worksheet.
Click your right mouse button on any worksheet cell. Does your right click menu appear now?
I think the sheet may be password protected.
Check in sample new file, if it happens the same.
If it works in sample file, check for below link for more troubleshooting steps:
This fixed everything but right clicking for on the sheets (e.g. to copy or change tab color). Is there a similar command for that?
Apologies, just as I entered my previous post, new posts came up that indicated the solution (renaming Excel12.xlb). That worked. Many thanks. Sorry for unnecessary post.
It's now November 2014, and I've got the same problem in my Excel 2007 application. The right-click context (shortcut) menus (in cells and columns/rows) do not work in any workbook, including a fresh workbook with no content, no macros, no add-ins, nothing. The menus are only disabled in my account. I can go to use Excel 2007 in another account and the context menus work fine there. I've tried to repair Office using the distribution DVD as an admin - did nothing. The problem seemed to start when I was experimenting with the RAND Excel function in cells.
This experimenting also caused Excel 2007 to not work at all, displaying an empty worksheet (no cells) and the following error on start-up "There was a problem sending the command to the program." I investigated that and found Microsoft Knowledge Base article KB211494. I tried that solution (Resolution: Turn off the "Ignore other applications that use Dynamic Data Exchange (DDE)" setting). That cleared up the start-up problem, but the context menus continue to be unavailable. Any advice would be greatly appreciated. Thanks.