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?

2 Answers

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.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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