top of page
The filter Tool has Basic and Advanced Functionality.
The Basic Filter Tool will delete entire rows if it can find an exact match with the filter term.
Step 1: Select a column to filter. A single cell is sufficient to select the entire column.
Step 2: Enter a filter term
Step 3: Select 'Filter Table'
In this example, the 'Part Number' column, column 'F' has been selected and the filter term is 'd'.
A warning will appear, confirming whether to proceed.
The basic filter will permanently delete filtered rows.
Advanced filter options can be utililzed by selecting the "Show Advanced Options" button. The form will expand to show the additional functionality.
Step 1: Select Filter Type
There are two Advanced Filter Types.
The first type, 'Filter Terms' is similar to the Basic Filter and allows the user to enter one or more filter terms to use at the same time.
The second type, 'Duplicates' allows the user to eliminate any item in the selected column that is a duplicate. The result is a list of unique items in the selected column. The user also has the option of skipping the deletion of the first duplicate.
Step 2: Select Options
The first Option 'Delete', will delete the entire row of every item matching the filter term(s).
The second option is to merely 'Hide' the rows matching the filter term(s),
The third option is to 'Highlight' rows matching the filter terms. Matches will be highlighted in magenta.
bottom of page