How To Delete Multiple Rows In Excel?

Home » How To Delete Multiple Rows In Excel » How To Delete Multiple Rows In Excel?

Maybe your like

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 “Right–click” 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.
By Kevin ArrowsUpdated on March 10, 2023Kevin is a certified Network Engineer Facebook Twitter LinkedIn Reddit Share via Email Print ABOUT THE AUTHOR Photo of Kevin Arrows

Kevin Arrows

  • Network Engineer (LAN/WAN) |
  • Twitter
  • LinkedIn
Kevin Arrows is a highly experienced and knowledgeable technology specialist with over a decade of industry experience. He holds a Microsoft Certified Technology Specialist (MCTS) certification and has a deep passion for staying up-to-date on the latest tech developments. Kevin has written extensively on a wide range of tech-related topics, showcasing his expertise and knowledge in areas such as software development, cybersecurity, and cloud computing. His contributions to the tech field have been widely recognized and respected by his peers, and he is highly regarded for his ability to explain complex technical concepts in a clear and concise manner.

Related Articles

Fix: Generative Fill Is Missing or Greyed Out in Photoshop

Published on December 18, 2025

How to Fix WinRAR Error: “Next Volume Is Required”

Published on December 16, 2025

How to Fix WinRAR Diagnostic Messages?

Published on December 15, 2025

How to Export and Import Contacts in Outlook?

Published on November 28, 2025

Fix: Davinci Resolve is Unable to Run in Cuda Mode

Published on November 1, 2025

Fix: Restart Office to Apply Changes to Your Privacy Settings

Published on October 30, 2025 Close Search for:
  • Facebook
  • Twitter
  • LinkedIn
  • YouTube
Close Search for Close Search for

Tag » How To Delete Multiple Rows In Excel