Mouse right click no longer working in excel

Anonymous
2010-03-19T21:59:21+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments
Answer accepted by question author
Anonymous
2010-03-20T04:35:08+00:00

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?

Was this answer helpful?

700+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2010-03-20T00:26:26+00:00

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:

http://support.microsoft.com/kb/919196

Was this answer helpful?

100+ people found this answer helpful.
0 comments

84 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-07T09:05:12+00:00

    This worked for me

    Open excel

    > hit alt-f11 to get to the VBE

    > hit ctrl-g to see the immediate window

    >

    > Type this and hit enter:

    > application.CommandBars("Cell").Reset

    >

    > Then enter this line below and hit enter:

    > application.CommandBars("cell").Enabled = True

    Cells now reset.

    To reset rows use this.

    In the immediate window

    > Type this and hit enter:

    > application.CommandBars("Row").Reset

    >

    > Then enter  this line below and hit enter:

    > application.CommandBars("Row").Enabled = True

    Rows now reset.

    To reset columns enter this.

    In the immediate window

    >

    > Type this and hit enter:

    > application.CommandBars("Column").Reset

    >

    > Then enter  this line below and hit enter:

    > application.CommandBars("Column").Enabled = True

    Columns now reset

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2014-11-03T20:39:30+00:00

    When my right click in Excel disappeared, I had to go to the Immediate window in Excel VBA and run the following commands one at a time:

       application.commandbars("Cells").enabled = true

       application.commandbars("Column").enabled = true

       application.commandbars("Row").enabled = true

    That seems to have fixed the problem.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-03-14T12:43:02+00:00

    That works!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments