How do I change settings to right-click to delete in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LadyG - 05 Feb 2007 16:32 GMT

When I want to delete a row I am forced to go to the Edit menu at the top.
But how can I change this to simply right-click, then select delete?

Reply to this Message

Gord Dibben - 05 Feb 2007 18:05 GMT

My Excel 2003 has a right-click>delete. As did earlier versions of Excel.

Select the row header and right-click.

Do you have "delete" command?

If so, click it.

If you have no "delete" available, you can reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").reset
End Sub

Gord Dibben MS Excel MVP

>When I want to delete a row I am forced to go to the Edit menu at the top.
>But how can I change this to simply right-click, then select delete?

Reply to this Message