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.
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.
