How do I change settings to right-click to delete in Excel?
My Excel 2003 has a right-clickdelete. 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 ViewImmediate 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
On Mon, 5 Feb 2007 08:32:01 -0800, LadyG
wrote:
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?
|