You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel Your email has been sent Applying multiple criteria against different columns to ...

Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos.

You can even edit DBF files in MS Excel using its variety of tools. Sort data, filter out data, apply formulas, calculate values, add different types, edit existing content of DBF file, insert new ...