How do you delete multiple rows in excel

Question

How do you delete multiple rows in excel, if I mark everything and try to delete it just deletes a single row.

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

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.