How to Remove Rows Based on Cell Value in Excel Without VBA
HTML-код
- Опубликовано: 10 июн 2024
- 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
/ excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Excel Tutorial for Beginners: goo.gl/UDrDcA
Intermediate Excel Tutorial: tinyurl.com/59a837py
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Text Case Conversion Techniques: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
ChatGPT Excel Mastermind: tinyurl.com/46kn7tmd
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
Website: msexceltutorial.com/
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 .
will this work: ruclips.net/video/MNckj0Em--k/видео.html
@@Excel10tutorial thanks brother, is there any way to check without unique numbers?
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
Can you remove formatting? select everything. Go to Home tab, editing group and clear format.