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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2017-11-21T11:30:39+00:00

    Tom's solution worked for me, but only for cells. When I right-click a tab or a row, nothing happens.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-08-29T18:09:27+00:00

    This is the solution that worked for me. 

    1. Open Excel and click Alt+F11 to open the VBAIDE
    2. Post the below code in a code module.
    3. Press F5 to execute the code. 
    4. Test and enjoy.

    Sub RightClickFix()

    Dim Cbar As CommandBar

    For Each Cbar In Application.CommandBars

        Cbar.Enabled = True

    Next

    End Sub

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-08-10T11:29:43+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?

    Thanks ITS worked for me

    Was this answer helpful?

    0 comments