Mrinmoy Roy
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.
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.
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.
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.
- Select the radio button Blanks from the Go To Special dialog box > press OK.
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!
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.
- 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.
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.
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.
- Deselect all from the pop-up window.
- Select only the Blanks option within the list.
- Press OK.
This time a table with only the blank rows will appear.
- Right-Click on the Table and select the Delete Row command.
- Press OK.
You will get back a table returned without the blank rows.
Here you go:
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.
This will place all the blank rows at the bottom of the table. Which you can simply ignore.
Delete Rows in Excel: Knowledge Hub
- Delete Rows in Excel Shortcut
- Delete Specific Rows in Excel
- Delete Selected Rows in Excel
- Delete Selected Rows in Excel VBA
- Delete Multiple Rows in Excel
- Delete Multiple Rows At Once
- Delete Multiple Rows in Excel Using Formula
- Delete Rows with Specific Text
- VBA Delete Rows with Specific Data
- Delete All Rows Not Containing Certain Text
- Delete Row If Cell Contains
- Macro Delete Row If Cell Contains 0
- Delete Multiple Rows with Condition
- VBA Delete Multiple Rows
- Delete All Rows Below a Certain Row
- Remove Empty Rows in Excel
- Excel Remove Blank Rows Formula
- Delete Blank Rows in Excel
- Excel Delete Empty Rows at Bottom
- Delete Empty Rows in Excel VBA
- Remove Highlighted Rows in Excel
- Delete Every Nth Row in Excel
- Delete Every Other Row in Excel
- Delete Every Other Row in Excel VBA
- Macro to Delete Rows Based on Criteria
- Excel Delete Row If Cell Is Blank
- Macro Delete Row If Cell Is Blank
- Macro Delete Row If Cell Contains Value
- VBA Delete Entire Row Based on Cell Value
- Delete Rows That Go on Forever
- Delete Infinite Rows
- VBA Delete Row
- VBA Delete Rows in Range
- VBA Code to Delete Rows Based on Multiple Cell Value
- Delete Hidden Rows in Excel
- Delete Hidden Rows in Excel VBA
- Delete Filtered Rows
- Filter and Delete Rows in Excel VBA
- VBA to Filter Data and Delete Rows
- Delete Unfiltered Rows in Excel VBA
- Delete Unused Rows in Excel
- Delete Excel Rows Based on Another List
- VBA Remove Duplicate Rows Based on One Column
- Delete Duplicate Rows in Excel VBA
- Delete Rows Without Affecting Formulas
- Remove Rows Containing Identical Transactions
- Not Enough Memory to Delete Rows in Excel
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
