How to Delete Rows in Excel: 7 Methods

While working with data in Excel, the deletion of rows is quite a common phenomenon. There are a good number of methods that we can use to delete rows in Excel. Different approaches seem to work in different situations. This article will show seven effective techniques to delete rows in Excel with examples and proper illustrations.


Download the Practice Workbook

In this practice workbook, we have included 8 sheets, each featuring an Employee Monthly Savings Calculation table to demonstrate 7 ways to delete any rows in Excel. You are recommended to download the workbook and practice along with it.


7 Ways to Delete Rows in Excel

In this article, you are going to learn about 7 different methods to delete any rows in Excel. So, without further discussion let’s dive straight into them:


1. Delete a Single Row in Excel

This is the most basic method to delete a single row in Excel. Follow the steps to learn it.

Steps:

  • Select the row > Right-Click on the selection area.
  • Click on Delete from the Context menu.

Delete a Single Row


2. Remove Consecutive Multiple Rows in Excel

If you want to delete a range of rows that are next to each other, then you can follow this guide step by step:

Steps:

  • Select the range of rows > Right-Click on the selection area.
  • Click on Delete from the Context menu.

Remove Consecutive Multiple Rows

Read more: How to Delete Multiple Rows in Excel 


3. Remove Non-Consecutive Multiple Rows

If you want to delete a range of rows that are not next to each other, then you can follow this guide step by step:

Steps:

  • Press and hold Ctrl and select the rows that you want to delete.
  • Right-Click on the selection area > Click on Delete from the Context menu.

Remove Non-Consecutive Multiple Rows

Read more: How to Delete Specific Rows in Excel 


4. Eliminate Blank Rows Using Go To Special

So far the methods we’ve discussed above are convenient to use for a smaller size of the dataset. But if the dataset contains thousands of rows then selecting each of them manually can be intimidating. But you don’t need to worry about that at all. Here we’ve brought an escape plan for you. Follow this method, this will make your life a lot easier and comfortable.

Steps:

  • Select the Table > Press Ctrl + G. This will navigate you to the Go To dialog box.
  • Select Special… from the Go To dialog box.

Eliminate Blank Rows Using Go To Special

  • Select the radio button Blanks from the Go To Special dialog box > press OK.

Eliminate Blank Rows Using Go To Special

This command will select all the blank rows within the table.

  • Right-Click on any one of the selected rows.
  • Select the Delete command from the Context window.

That’s it!

Eliminate Blank Rows Using Go To Special

Read more: How to Use VBA to Delete Empty Rows in Excel


5. Delete Blank Rows Using the Find Command in Excel

This method is also convenient to use for a larger amount of datasets. Here are the steps to follow:

  • Select the Table.
  • Go to the Find and Replace dialog box by pressing Ctrl+F.
  • Select Options from the dialog box.

Clean Up Blank Rows Using Find Command

  • Leave Find What box blank > Select Sheet from the Within drop-down list.
  • Select Values from the Look-in drop-down list.
  • Mark the Match entire cell contents checkbox > Press Find All.
  • Press Ctrl+A to select all the blank rows > Close the Find and Replace dialog box.

Clean Up Blank Rows Using Find Command

Now, you’ve got all the blank rows within the selected table. Now follow the below steps to delete them all.

  • Right-Click on the selection area.
  • Select the Delete command from the Context menu.

Clean Up Blank Rows Using Find Command

Read more: How to Delete a Row If a Cell is Blank in Excel


6. Delete Blank Rows Using the Filter Option in Excel

You can even use this method instead of the previous two methods. All of them serve the same purposes.

  • Select the Table.
  • Go to the Data tab and then click on Filter.
  • Click on the arrow icon that appears in the Name column.

Delete Blank Rows Using Filters

  • Deselect all from the pop-up window.
  • Select only the Blanks option within the list.
  • Press OK.

Delete Blank Rows Using Filters

This time a table with only the blank rows will appear.

  • Right-Click on the Table and select the Delete Row command.

Delete Blank Rows Using Filters

  • Press OK.

Delete Blank Rows Using Filters

You will get back a table returned without the blank rows.

Here you go:

Delete Blank Rows Using Filters


7. Delete Blank Rows in Excel By Sorting

By following this method, you are not actually deleting any rows so to speak. You will be just sorting out the blank rows at the bottom which you may simply ignore.

  • Select the entire Table.
  • Go to the Data tab.
  • Select the Sort A to Z command.

Drop Blank Rows By Sorting

This will place all the blank rows at the bottom of the table. Which you can simply ignore.

Drop Blank Rows By Sorting


Conclusion

In this article, we’ve discussed 7 different methods that you can use to delete any rows in Excel. We recommend practicing all of them using the given practice workbook to find which one best suits your case. You can drop any queries regarding the deletion of rows in Excel in the comment box. We will try to respond as soon as possible.


Related Readings

 

Mrinmoy

Hi! This is Mrinmoy. I write about Excel and VBA stuff for Exceldemy. I have my graduation completed from Khulna University of Engineering & Technology, Bangladesh. I have an immense interest in Datascience and Machine Learning. I like to play guitar and watch Tedtalks in my leisure time. I used to be an indie filmmaker and a wedding photographer. I'm liberal to any kind of constructive criticism and inclined towards expanding my learnings.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo