How to Remove Rows Based on Cell Value in Excel Without VBA

*How to Remove Rows Based on Cell Value in Excel Without VBA*
In this intermediate excel tutorial, I’ll show you two different ways to delete entire row based on text in excel. I’ll be using Excel’s built in features to do it and I’ll not be using any vba in this tutorial. Here it goes:

0:00 How to Remove Rows Based on Cell Value in Excel Without VBA
We have a sample dataset where we want to remove entire row based on the text or cell value on column C. Follow the steps to remove rows based on cell value.

*Method: 1*
0:40 Remove rows based on cell value using filter in excel
*Step: 1* Click on the header row and press Ctrl + Shift + L to insert filter
*Step: 2* Filter the column (where you have your specific text) and only keep the text you need to delete
*Step: 3* Select the filter dataset and right click on it.
*Step: 4* Click on Delete row and then select “Delete Entire Sheet Row”
*Step: 5* Click on the header row and press Ctrl + Shift + L to remove filter
Done. In this way you can now remove row based on text

*Method: 2*
1:53 Delete rows based on text using Find and replace feature in excel
*Step: 1* Select the column by clicking on the column name where you have your specific text
*Step: 2* Press Ctrl + F to open Find and replace feature
*Step: 3* Write the text based on which you need to remove rows and click on “Find All”
*Step: 4* Now press CTRL + A to select All
*Step: 5* without clicking on the find and replace dialogue box, Right-click on any selected value from your worksheet and click Delete.
*Step: 6* Select “Entire Row” and click ok.
Done. You have successfully removed row based on cell value in excel without using any vba.

#Excelrows #reomve #excelfilter
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[ganapathi]

Hi bro could you please advise on the below scenario:

In the above set off data which you showed in the video, how to pull out data for revenue without using filter function, I want values by using vlokkup/xlookup but if I use vlookup the next value of revenue is not showing it is pulling out first value of revenue .

[lmarshall]

I have a problem with a text file - it has some kind of hidden characters or something - like page breaks 🤷‍♀️

So will filter and select the 1st group of accounts - but nothing after

So I have to manually go thru after the first set and delete rows (cleaning the file for upload to our database)

So frustrating - nobody else in our IT group can get that file to filter correctly

So we can only automate to a point