Page 39 - Touchpad_Plus_V3.2_Class 7
P. 39
Perform the following steps to apply a Standard Filter:
Step 1 Select the range of cells you want to filter, including the headers.
Step 2 Click on the Data menu.
Step 3 Click on the More Filters option.
Step 4 Click on the Standard Filter option. The Standard Filter dialog box will open.
Step 5 Under the Filter Criteria section, in the Field Name drop-down list, select Department
as the first criterion.
Step 6 In the Condition drop-down list, select equals (=).
Step 7 In the Value drop-down list, select Sales to filter for employees from the Sales department.
Step 8 To add another filter condition, in the second row of the Filter Criteria section, in the
Field Name drop-down list, select Years of Experience as the second criterion.
Step 9 In the Condition drop-down list, select greater than (>).
Step 10 In the Value drop-down list, enter 2 to filter only rows where the years of experience
are greater than 2.
Step 11 Under the Operator drop-down list, choose AND to connect rows that meet both filter
criteria.
Step 12 Once you have set up all criteria, click the OK button.
Using Standard Filter
You will notice that only the details of the employees who are from the Sales department and
have more than 2 years of experience are displayed, and the rest of the rows are hidden.
Remove Filters
The AutoFilter, once applied, can be easily removed. Perform the following steps to remove
AutoFilter:
Step 1 Select the range of data where the AutoFilter was applied in the worksheet.
Step 2 Click on Data menu.
Step 3 Click on the AutoFilter option.
You will notice that the filter arrows in front of the column headers will disappear, and any
hidden rows will reappear.
More on Calc 37

