How can I delete multiple rows in Excel? If I mark everything and try to delete, it just deletes a single row. Even if I right-click and select delete, it still deletes one row at a time.

I need to delete all rows separately selected with Ctrl in one go.

  • 1
    Which version of Excel are you using? The way you describe works for me in Excel2007. – TheUser1024 Nov 15 '12 at 20:03

Select the rows you want to delete and hit Ctrl+- (minus). If you select the whole row, you will not be prompted, if you only select some cells you will be prompted what you want to do exactly.

Edit: btw. Ctrl++ inserts rows.


Using Ctrl to select, then right click to delete entire rows works. But, maybe it is not that obvious that it works. Try to right click and delete contents first, then delete the rows.

Have you tried this on a new workbook? Maybe, the workbook you are working on has some additional functionality, which prevents the default behavior. But be ensured, usually it should work the way you tried.


If the data is in the form of an official 'table' you won't be able to select different selections of multiple rows to delete in one go. You have to copy and paste the data into an empty worksheet (without the 'table' formatting) and you should be able to do what you describe.

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.