Deleting Records based on criterion

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

Bruce Roberson

I know about advanced filters and filtering out records
based on a criterion.

But if I wanted to use the approach of deleting the
records that don't match a criterion, how would I go about
this in Excel?

I would rather not use a macro for this unless its the
only way.

Thanks,


Bruce
 
After you do your Autofilter (or in-place Advanced Filter) only the rows to
be deleted will be visible. Select these rows (you only need to select one
column) and do an Edit, Delete Row. Click Ok to the confirming prompt.
Only the visible rows will be deleted (Excel is pretty smart<g>) just as you
wanted.
 
Back
Top