How to Delete Multiple Rows in Excel?

Excel is a spreadsheet program developed and distributed by Microsoft. It was first made popular in 1993 after version 5 released and has since replaced the widely popular “Lotus 1-2-3” as the industry standard. The program is a part of the Microsoft Office package that provides some basic programs that are widely used in the businesses, industry, and offices.

Excel divides the spreadsheets in “Rows” and “Columns”. A set of vertical boxes is called a column and a set of horizontal boxes is called a row. In this article, we will discuss some of the easiest methods to delete multiple rows in Excel without damaging the spreadsheet. Make sure to follow the steps carefully and accurately in order to avoid data loss.

How to Delete Multiple Rows in Excel?

After receiving numerous requests on a tutorial to delete multiple rows in excel, we tested and compiled a couple of the easiest methods which are listed below.

Method 1: Using Delete Button

1. Press “Shift” and “Click” to select the Rows that you want to delete.

   

2. Press the “Del” button on your keyboard to delete the selected Rows.

   

3. Click on “OK” if a warning prompt comes up.
4. The rows should now be deleted.

Method 2: Using Menu

1. Press “Shift” and “Click” to select the Rows that you want to delete.

   

2. Press the “Right–click” button on your mouse to open the menu.
3. Click on the “Delete Row” option to completely remove the selected Rows.

   

4. Click on “OK” if a warning prompt comes up.
5. The rows should now be deleted.

Note: Make sure to remove any filters before trying any of the above-mentioned methods because if a filter has been applied, Excel only lets you delete one row at a time.

Method 3: Using Minus Button

1. Press and hold the “Ctrl” button.

   

2. Hit the “Minus” button and let go of the “Ctrl” button.
3. Press “R” on your keyboard to select Rows.
4. Press “Enter” to complete the process.