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.

Multiple rows selected Excel

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.
    Pressing Shift and clicking on the Rows in Excel to select them
  2. Press the “Del” button on your keyboard to delete the selected Rows.
    Pressing the “Del” button on the keyboard to delete 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.
    Pressing the Shift button and then clicking on the Rows to select them
  2. Press the “Rightclick” button on your mouse to open the menu.
  3. Click on the “Delete Row” option to completely remove the selected Rows.
    Clicking on the Delete Row button
  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.
    Pressing the “Ctrl” key on the keyboard
  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.

Kevin Arrows


Kevin is a dynamic and self-motivated information technology professional, with a Thorough knowledge of all facets pertaining to network infrastructure design, implementation and administration. Superior record of delivering simultaneous large-scale mission critical projects on time and under budget.

Expert Tip

How to Delete Multiple Rows in Excel?

If the issue is with your Computer or a Laptop you should try using Reimage Plus which can scan the repositories and replace corrupt and missing files. This works in most cases, where the issue is originated due to a system corruption. You can download Reimage by clicking the Download button below.

Download Now

I'm not interested

Close