Charlie Day
New Member
I have a table with 10 columns and 35000 rows, I want to lookup 15 names that I want to delete from the table, is there a faster way to do that rather than finding and deleting manually?
Find the list of names in a large table
- Thread starter Charlie Day
- Start date
Chihiro
Excel Ninja
CTRL + F, Find All.
Or if you know the column, Autofilter. Filter for the name, and delete visible range. Repeat for each of 15 names.
Alternately use Advanced Filter in Place to show 15 names and delete visible range.
https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/
Or if you know the column, Autofilter. Filter for the name, and delete visible range. Repeat for each of 15 names.
Alternately use Advanced Filter in Place to show 15 names and delete visible range.
https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/