Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
1  
Which version of Excel are you using? The way you describe works for me in Excel2007. –  TheUser1024 Nov 15 '12 at 20:03
add comment

3 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.

share|improve this answer
1  
+1 - this is quite a shortcut, nice! –  Jook Nov 15 '12 at 10:28
add comment

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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