Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 2 down vote favorite

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
We need more information about your system before we can help. – Randolph West Nov 22 '11 at 22:42
see updated question, @RandolphWest. – studiohack♦ Nov 22 '11 at 22:55

migrated from stackoverflow.com Nov 22 '11 at 19:16

1 Answer

up vote 1 down vote

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
Next

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. – Randolph West 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.