If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change settings to right-click to delete in Excel?
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|