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.
14 Answers
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.
1If 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.
1I tried the suggestion of using Ctrl and drag to select multiple cells. Del (not Backspace) works to delete the contents all at once for me.
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.
