Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows.

Do you know if this functionality does not exist in Excel 2010 or if my Excel installation is problematic and what I need to do to resolve this?

Update: I am using Windows 7 64 bit and my Office is the Home and Business Edition.

share|improve this question

migrated from Nov 22 '11 at 19:16

This question came from our site for professional and enthusiast programmers.

We need more information about your system before we can help. – user3463 Nov 22 '11 at 22:42
see updated question, @RandolphWest. – studiohack Nov 22 '11 at 22:55

hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window Enter the following

application.CommandBars("cell").Enabled = True
application.CommandBars("column").Enabled = True
application.CommandBars("row").Enabled = True

alt-f11 to return to excel

share|improve this answer

Start Excel in safe mode and see if the problem persists. It may be an add-in that is stealing the functionality.

To open Excel in safe mode, find an Excel document, and hold down Ctrl when double-clicking on it. You should be prompted to open in Safe Mode.

EDIT: There's a VBA macro you can use from this site, which will apparently restore right-click behaviour:

Sub SwitchOnCutAndPaste()

EnableControl 21, True
EnableControl 19, True
EnableControl 22, True
EnableControl 755, True

End Sub

Sub EnableControl(Id As Integer, Enable As Boolean)

Dim CB As CommandBar
Dim CBC As CommandBarControl

For Each CB In Application.CommandBars
    Set CBC = CB.FindControl(Id:=Id, recursive:=True)
    If Not CBC Is Nothing Then CBC.Enabled = Enable

End Sub
share|improve this answer
Thank you. I opened excel in safe mode and indeed the right click menu appears normally when I select entire rows or columns. However, there is no add-in installed when I open a normal excel. Could it be that an add-in that was previously installed removed the right click menu permanently (possibly with a VBA command)? And if yes, how can I restore it? – Financial Economist Nov 23 '11 at 20:42
See my revised answer. I can't speak for whether this works, but it's certainly worth a shot. – user3463 Nov 24 '11 at 1:12
Thanks a lot for the answer but unfortunately it does not work. I ran the macro but no luck. This is very weird. I have been using excel for ages and have not come across a similar issue. – Financial Economist Nov 24 '11 at 20:22

This worked for me:

Hit Alt+F11 to get to the Visual Basic Editor, hit Ctrl+G to see the immediate window, and enter the following:

Application.CommandBars("cell").Enabled = True
Application.CommandBars("Ply").Enabled = True
Application.CommandBars("row").Enabled = True
Application.CommandBars("column").Enabled = True

Alt+F11 to return to Excel.

"ply" is the code used to enable right click of worksheet tabs.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .