How do you delete multiple rows in excel

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

0

7 Answers

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

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

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.

2

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

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

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.

For anyone else also googling this solution:

Remember to remove any filters before attempting to delete multiple rows, otherwise it will only let you delete a single row even when selecting more than one.

1