How to Delete Specific Rows in Excel (8 Quick Ways)

To delete specific rows in excel is a too common task in our day-to-day life while using Excel. In this article, I’ll show 8 quick methods to delete specific rows in excel. Just have a sharp look at the screenshots and follow the steps carefully.

Download Practice Book

Download the Excel workbook that we’ve used to prepare this article.

8 Quick Methods to Delete Specific Rows in Excel

Method 1: Use Home Ribbon to Delete Specific Rows in Excel

Let’s get introduced to our workbook first. Here I have used 3 columns and 7 rows to represent some Sales Representatives and their sales in different regions.

Now in this method, we’ll delete specific cells by using the Home tab.

Step 1:

➽ Select any cell of the row that you want to delete.

Step 2:

➽ Then follow Home > Cells > Delete > Delete Sheet Rows.

Now see the selected row is deleted.

Read More: Excel Shortcut to Delete Rows (With Bonus Techniques)

Method 2: Use Context Menu Option to Delete Specific Rows in Excel

Here we’ll do the same operation by launching the Context Menu with a mouse.

Step 1:

➽ Press the row number that you want to delete.

Step 2:

➽ Then Right-click the mouse

➽ Select the Delete option.

Look the selected row is no more in your Excel sheet.

Read More: Delete Row If Cell Contains Specific Values in Excel (3 Easy Ways)

Method 3: Delete Rows that Contain a Specific Text in Excel

Now we’ll do the operation in a different way. We’ll delete rows here according to a region name. Let’s see how to do it.

Step 1:

➽ Select any cell of the datasheet.

➽ Then press Data > Filter. 

After that, the Filter button will appear in every header of the columns.

Step 2:

➽ Launch the Filter option from the Region header. A dialog box will appear.

➽ Then select the region you want to delete. I have selected “Alaska”.

➽  Press OK

The data table will now appear only with the Alaska region

Step 3: 

➽ Now just select the rows, Right-click and press Delete Row.

See the rows are deleted.

Step 4:

➽ Then again click on the Filter button in the Region header.

➽ Mark (Select All)

➽ Press OK

You will get back the other rows at once.

Read More: How to Delete Rows in Excel with Specific Text (3 Methods)

Method 4: Delete Rows Based on a Numeric Condition in Excel

Here I’ll show how to delete rows based on a numeric condition. It’s like the previous method.

Step 1: 

➽ Tap on the Filter button in the Sales title box which contains numbers.

➽ Mark on the number you want to delete.

The data table is now filtered with that number.

Step 2:

➽ Select the rows.

➽ Then Right-click your mouse > Delete Row.

Read More: How to Delete Multiple Rows in Excel with Condition (3 Ways)

Similar Readings

• How to Delete Hidden Rows in Excel VBA (A Detailed Analysis)
• How to Delete Rows in Excel without Affecting Formulas (2 Quick Ways)
• Delete Unfiltered Rows in Excel Using VBA (4 ways)
• How to Delete Row Using Macro If Cell Contains 0 in Excel (4 Methods)
• How to Delete Rows in Excel That Go on Forever (5 Easy Ways)

Method 5: Sort the Dataset and Then Delete the Specific Rows in Excel

In this method, I’ll sort the dataset first and then I’ll delete some specific rows.

Step 1:

➽ Select any cell of the data.

➽ Then press Data > Sort.

A dialog box will appear.

Step 2: I’ll sort by Region. So follow the steps.

➽ Select Region in Sort by option.

➽ Select Cell Values in Sort on option.

➽ Select A to Z in the Order option.

➽ Press OK

The regions are now sorted in alphabetical order. Here I’ll delete the Alaska region.

Step 3: 

➽ Select the rows that contain the text ‘Alaska’.

➽ Then Right-click your mouse > Delete

Read More: Excel VBA to Delete Rows with Specific Data (9 Examples)

Method 6: Find and Select the Cells Based on Cell Value and Then Delete the Rows in Excel

Here, we’ll use the Find and Select option to delete rows in Excel.

Step 1:

➽ Select the whole dataset.

➽ Then go to Home > Editing > Find & Select > Find.

A dialog box will appear.

I’ll find the region ‘Alaska’ here.

Step 2: 

➽ Type ‘Alaska’ in the Find What option.

➽ Press Find Next.

Step 3: 

➽ Then press Find All. It will show all the cells containing “Alaska”.

Step 4:

➽ Now select those cells > Right-click your mouse > Delete.

That rows are removed now.

Read More: How to Delete Entire Row Based on Cell Value Using VBA in Excel

Method 7: Delete All Rows With a Blank Cell in Excel

In this method, we’ll delete rows containing Blank cells.

Step 1: 

➽ Select the dataset.

➽ Press the F5 key.

A dialog box named “Go To”  will appear.

➽ Press Special.

Then another window will appear named “Go To Special”.

Step 2:

➽ Mark on Blanks option.

➽ Press OK

Now the Blank cells will be highlighted.

Step 3: 

➽ Now select the rows that are containing highlighted Blank cells.

➽ Then Right-click your mouse > Delete

Read More: How to Delete Blank Rows in Excel (6 Ways)

Method 8: Delete Specific Rows Using VBA in Excel

In the last method, I’ll show how to delete rows using VBA.

Step 1: 

➽ Press Alt+F11. A VBA window will open up.

➽ Then press Insert > Module

A new module will appear on the VBA window.

Here I’ll delete rows from 5 to 7. You can change the criteria in the given codes.

Step 2: 

➽ Now type the codes given below.

Option Explicit
Sub sbDeleteARowMulti() 
Rows("5:7").Delete 
End Sub

Step 3:

➽ Then press Run > Run Sub/UserForm

Look at the image below, the rows from 5 to 7 are deleted.

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

Conclusion

I hope all of the methods described above will be effective enough to delete specific rows in Excel. Feel free to ask any questions in the comment section and please give me feedback.

Related Articles

• How to Delete All Rows Not Containing Certain Text in Excel
• How to Remove Rows Containing Identical Transactions in Excel
• [Fixed!] Not Enough Memory to Delete Rows Error in Excel
• How to Delete Rows Based on Another List in Excel (5 Methods)
• VBA to Delete Every Other Row in Excel (6 Criteria)
• How to Delete Multiple Rows in Excel at Once