- Select the column that contains the value or string that you want to set as the filter criteria.
- Select Data -> Instant Filter.
An arrow button is added to the head of the column.
- Click the arrow button.
The records that match the selected filter criteria are shown.
- You can sort the filtered column by clicking Sort Ascending or Sort Descending at the beginning of the filter list.
You can select multiple keywords from the filter list. If multiple keywords are selected, the rows that contain these keywords are displayed. Hidden rows are not included.
Parent topic: Managing data ranges