AutoFilter

AutoFilter is a data filtering feature found in many spreadsheet and database programs that lets users quickly restrict the visible rows of a data range to those meeting specified criteria. It is commonly used in applications such as Microsoft Excel, LibreOffice Calc, and Google Sheets (under the general filter functions, with terminology varying by program).

How it works: When AutoFilter is activated, a filter control appears in the header row of the data range or table. Each column presents a drop-down menu from which users can select one or more values to include, or apply custom criteria based on text, numbers, or dates. The software hides rows that do not meet the chosen criteria while keeping all data in place. Filters can be combined across multiple columns, and the results can be sorted or copied as needed. Clearing filters restores the full dataset.

Applications and limitations: AutoFilter is useful for quick data exploration, subsetting data for reports, and temporarily excluding irrelevant records. It is not a substitute for permanent data removal, since hidden rows remain in the worksheet and can be redisplayed by clearing filters. Complex criteria across multiple columns may require advanced filtering options or manual steps in some programs.

Implementation notes: In Excel, enable filtering by selecting a data range and choosing the Filter command; in Excel Tables, filter buttons appear automatically in headers. Google Sheets provides a similar capability via Data > Create a filter or Filter views. Other spreadsheet tools offer equivalent AutoFilter or standard filter features as part of their data handling tools.