Excel Shortcut to Delete a Row [3 Video Demos]

Deleting rows in Excel using a shortcut

In this tutorial, I will show you how to delete rows by using the keyboard shortcut. You can watch the video demos below or see the step-by-step.

Shortcut for deleting a row

Use the following shortcut for deleting a row:

Ctrl + –

(Press Ctrl key along with the minus key)

Video demo of deleting a row

Watch the video demo below for deleting the rows one by one:

 

Step by Step of deleting a row

Step 1:

Select a cell or click on the cell of the row that you want to delete.

Step 2:

Press the following keys:

Ctrl + –

Deleting multiple rows by shortcut

For deleting multiple rows using the above shortcut, follow these steps.

Step 1:

Press Shift + Spacebar to select a row.

Step 2:

Press Shift + Down/Up arrow key.

It will select rows downwards/upwards depending on the arrow you pressed.

Step 3:

Press the shortcut:

Ctrl + –

It should remove all the selected rows.

Video Demo of removing multiple rows

How to recover deleted rows immediately

Accidentally removed a row that you did not want to?

If you have not closed the Excel sheet then press the following keys to recover the deleted rows.

Ctrl + z

Keep on pressing this shortcut if you want to undo the removal of multiple rows using the above shortcut.

How to remove multiple rows using the mouse?

Step 1:

Select the adjacent rows that you want to delete by clicking the cell header.

Step 2:

Right-click on any area of the selected rows.

Step 3:

Click on the “Delete” option on the pop-up menu.

Excel-delete-rows

Watch the video demo

Deleting non-adjacent rows

Step 1:

In order to delete non-adjacent rows, press the Ctrl key and click on the row headers one by one.

Step 2:

Right-click on any area of the selected rows.

Step 3:

Click on the “Delete” option on the pop-up menu.