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 do you delete multiple rows in excel, if I mark everything and try to delete it just deletes a single row.

share|improve this question

migrated from stackoverflow.com Mar 29 '11 at 6:37

This question came from our site for professional and enthusiast programmers.

add comment

4 Answers

I'm personally a fan of right-click (or control click on an Apple) and select delete from the pop-out menu. That will also delete the rows, not just clear out the data.

share|improve this answer
    
"That will also delete the rows, not just clear out the data." -> This is especially important since Excel seems to mark cleared cells as if they are still in use. If you then use that Excel file as a data destination (for example, outputting data from Integration Services into the Excel file), you might find that your data begins to appear right below the last cleared row instead of at the beginning of the cleared cells. Thanks for bringing it up. –  enriquein Mar 29 '11 at 4:43
    
+1 - Selecting rows then hitting <delete> or <backspace> is deleting the contents of the last highlighted cell of the selection. –  Dawson Mar 29 '11 at 7:15
add comment

You're using backspace instead of the 'Delete' key. Use the 'Delete' key for that.

share|improve this answer
add comment

Click + Shift or Shift + Click on the Row Header (the number cell at the far left) to select multiple rows and either "delete" or right click to the context menu and delete.

Cheers,

CEC

share|improve this answer
add comment

If you want to delete row contents, then select multiple rows from Row Headers (Left most of your screen normally) and press Delete key. However, if you want to delete rows entirely, then select multiple rows and then right click->Delete will do the trick.

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.