Unable to Right click for Format Cells, Insert or delete

[lhuffhines]

Just recently My Excel 2010 has decided to not let me right click to format cells, delete or insert rows. I can do these functions from the ribbon, but not via right click. this happens in both existing spreadsheets where I am the author, or even a brand new spreadsheet like in the image below. we have restarted the computer, Uninstall and reinstalled Office and still get same symptoms. I got here thru google but cannot find an answer anywhere.

I am very computer literate and even our IT personnel have looked at this with no answer. any help is appreciated. as you can see in the image, these options are greyed out.

Running Office standard 2010, Windows 7 pro x64

 

[Trevor G]

Welcome to the forum,

I am sure you have tried this, but here goes.

Have you created a workbook which gives you the issue and then save and pass onto another PC with the same version and then see if that machine does the same when they open the workbook.

 

[lhuffhines]

Welcome to the forum,

I am sure you have tried this, but here goes.

Have you created a workbook which gives you the issue and then save and pass onto another PC with the same version and then see if that machine does the same when they open the workbook.

yes. it worked for them

 

[Trevor G]

Compare all the settings from the File Tab (Backstage) and options to see if they match, if still not working then it maybe a windows issue rather than just install microsoft issue.

 

[lhuffhines]

We hunted thru all the options on the File tab and nothing about the menu's onthe mouse click. nothing about protection on the workbook.

 

[Trevor G]

Its a sad thing to say but it sounds like a window issue, so rather than search for missing registry data it might be easier to wipe the pc and re-install windows then Microsoft.

 

[lhuffhines]

Ugh.. thats an answer I DONT Want to see....

 

[lhuffhines]

AH HA!!!!!

http://answers.microsoft.com/en-us/...-options/04de39d7-a389-488c-91bc-be69b8243214

Go to the VBE (Alt/F11), press Ctrl/G, enter this:
commandbars("Cell").Reset

or

"I have tried this and it didn't work. I did finally find the solution that worked for me before and it's to go to regedit and delete HKEY_CURRENT_USER\Software\Microsoft\Office|12.0\Excel\Options."

The first worked for me doing the VBE

 

[jbarker2160]

Press Alt+F11
Double Click on a Worksheet
Paste the below code and press F5.

Sub reset()
On Error Resume Next

For Each c In Application.CommandBars
c.reset
Next

End Sub

This always works for me.

 

[bbott]

I realize this is an old post....but in case anyone has this issue and has Essbase installed....

I went to the options menu in Essbase, clicked on the Global tab, and selected 'Limit to Connected Sheets' n the 'Mouse Actions' options. That seemed to work for me.