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)
When I right click in excel I have only a few formatting options and lost all my menu options like add comment or hyperlink ect. Following other post, I have already started excel in SAFE mode and nothing changed. How can i get my full "right click" menu back?
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.
Alt + F11 to open VB Editor then View>Immediate Window
Type Application.CommandBars("Cell").Reset then hit Enter
Alt + q to return to worksheet and right-click menu should be reset to default.
How did it get mucked up to start with? Opened some workbook containing code?
Gord
re: right-click menu abridged on all workbooks
Gord's recommendation usually takes care of right-click menu problems.
You may have ignored his caution about workbooks with code altering the menu.
I would still check for add-ins and com add-ins that might be causing the problem.
Also, Windows10 has caused screwups with Windows and Office.
Another "remedy": with Excel close****d , is to delete the Excel??.xlb file. (11,12,14,15,16)
That file contains the menu configurations for XL (menus and ribbon) and will be automatically rebuilt after Excel is started.
Any customizations will be lost.
You may have to do a file search to find it.
In my older Windows version (not Windows10) the file is located here...
C:\Documents and Settings\James Cone\Application Data\Microsoft\Excel
'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)
(free & commercial excel add-ins & workbooks)
Thank you Gord for the reply. I am not sure how this happened or exactly when. I found the answer you sent me in someones question/reply and that does work. The bigger issue for me is when I open a new workbook from Excel, I have no options there either, its not just the workbook I though it was in but rather in all my workbooks. Any thoughts on how to correct this?
I have not upgraded my version of Excel beyond 2007 so I am not familiar enough with the structure of 2013 to be able to hazard a guess beyond my original attempt to restore your right-click menu.
Gord