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.

6 Answers 6

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

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

share|improve this answer

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

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

Content-wise: Mark the rows you'd like to delete and hit Del.

If you want to delete the rows, i.e. you want to reduce the number of rows:

  • hold Ctrl, hit - (minus sign), then let go of Ctrl

  • hit r (for selecting r ows, you'll observe you can use c for c olumns)

  • hit ENTER

share|improve this answer

Ctrl+Shift+Down will select all the rows down the current selection till a row which has text.

Click on the Row Header to highlight the entire row and press Ctrl+Shift+Down

share|improve this answer

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.