What is the keyboard shortcut for deleting selected rows?

Currently I select rows with shift+ up/down and click Ctrl + - and click r and press Enter. Is there a single key combination which I can use for doing this at one press?


This is actually two step action to delete rows in excel:

Step:1 Select the row to be deleted: Shift+Space
Step:2 Delete row: Ctrl+-


Click on the number of the row to select the entire row and press Ctrl + -. There is no need for r when entire row is selected.

  • u mean right click on that? – Vignesh Subramanian Mar 14 '16 at 10:41
  • Just left click on the number of the row or shift + space shortcut for selecting row where your cursor is then Ctrl + - – user555689 Mar 14 '16 at 13:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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