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-05-12T13:19:21+00:00

    Thanks for this. I have used this to solve this issue which has been repeatedly affecting my team due to some forms we are required to fill that disable the right click. I have the cells, rows and columns enabled again thanks to this post and have enabled the excel tabs  again via another post.

    In typical Columbo fashion however there's just one more thing. Right click is still disabled for pivot tables and I presume charts. Any suggestions on how to enable again for that. Am using Excel 2010 and can't even get the pivot table field list to display because of this, this is really causing me problems.

    Thanks, R.

    Was this answer helpful?

    0 comments
  2. 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
  3. Anonymous
    2017-03-17T09:12:11+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?

    This was helpful. I just followed the instructions.

    Thank you.

    Was this answer helpful?

    0 comments