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 Detele 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.

Use Home Ribbon to Detele Specific Rows in Excel

Step 2:

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

Use Home Ribbon to Detele Specific Rows in Excel

Now see the selected row is deleted.

Use Home Ribbon to Detele Specific Rows in Excel

Read more: How to Delete Rows in Excel


Method 2: Use Context Menu Option to Detele 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.

Use Context Menu Option to Detele Specific Rows in Excel

Step 2:

➽ Then Right-click the mouse

➽ Select the Delete option.

Use Context Menu Option to Detele Specific Rows in Excel

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

Use Context Menu Option to Detele Specific Rows in Excel

Read more: How to Delete Selected Rows in Excel


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.

Delete Rows that Contain a Specific Text in Excel

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

Delete Rows that Contain a Specific Text in Excel

The data table will now appear only with the Alaska region

Delete Rows that Contain a Specific Text in Excel

Step 3: 

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

Delete Rows that Contain a Specific Text in Excel

See the rows are deleted.

Delete Rows that Contain a Specific Text in Excel

Step 4:

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

➽ Mark (Select All)

➽ Press OK

Delete Rows that Contain a Specific Text in Excel

You will get back the other rows at once.

Delete Rows that Contain a Specific Text in Excel

Read more: How to Delete Multiple Rows in Excel with Condition 


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.

Delete Rows Based on a Numeric Condition in Excel

The data table is now filtered with that number.

Delete Rows Based on a Numeric Condition in Excel

Step 2:

➽ Select the rows.

➽ Then Right-click your mouse > Delete Row.

Delete Rows Based on a Numeric Condition in Excel


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.

Sort the Dataset and Then Delete the Specific Rows in Excel

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.

Sort the Dataset and Then Delete the Specific Rows in Excel

Step 3: 

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

➽ Then Right-click your mouse > Delete

Sort the Dataset and Then Delete the Specific Rows in Excel


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.

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

I’ll find the region ‘Alaska’ here.

Step 2: 

➽ Type ‘Alaska’ in the Find What option.

➽ Press Find Next.

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

Step 3: 

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

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

Step 4:

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

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

That rows are removed now.

Find and Select the Cells Based on Cell Value and Then Delete the Rows 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.

Delete All Rows With a Blank Cell in Excel

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

Step 2:

➽ Mark on Blanks option.

➽ Press OK

➽ Press Special.

Now the Blank cells will be highlighted.

Step 2: ➽ Mark on Blanks option. ➽ Press OK

Step 3: 

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

➽ Then Right-click your mouse > Delete

Step 2: ➽ Mark on Blanks option. ➽ Press OK


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.

Delete Specific Rows Using VBA in Excel

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

Delete Specific Rows Using VBA in Excel

Step 3:

➽ Then press Run > Run Sub/UserForm

Delete Specific Rows Using VBA in Excel

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

Delete Specific Rows Using VBA in Excel

Read more: Delete Multiple Rows in Excel with VBA


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

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Excel is an amazing softwear. Here i will post excel related useful articles. I am a graduate from Bangladesh University of Engineering and Technology. I love to learn new things and work with it. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo