Delete Cells Left

[MikeyZ]

Is there a shortcut to Deleting Cells Left, rather than Right Click/Delete/Delete Cells Left

Something quicker!!!
??

 

[pagrender]

Hitting Control and the minus sign brings up the delete menu. That's not much of a shortcut but it might help.

You can also use F4 to repeat your last command. After you delete to the left once, hit F4 and it will do it again.

 

[pagrender]

I guess a macro could do it to:

Sub DeleteLeft()
Selection.Delete Shift:=xlToLeft
End Sub

Then assign a keyboard shortcut (using Macros/Options) to the macro, such as Control-Q

 

[Jonmo1]

You can do

ALT + E
D
L
Enter