Page 38 - Touchpad_Plus_V3.2_Class 7
P. 38
Unfiltered data
Step 2 Click on the Data menu.
Step 3 Select the AutoFilter option. You will notice that small arrows appear in front of
all the column headers.
Step 4 Click on the arrow in front of the header Department to open a drop-down list. You will
notice that all the entries in the column are present in the list with small checkboxes in
the beginning.
Step 5 Click on Sales checkbox to uncheck it.
Step 6 Click on the OK button.
Using AutoFilter option Using filter options
Filtered data
You will notice that the rows of unchecked data are
removed from the list. You need not to worry as the The moon highlights different aspects
data is not lost. Notice the row headings. Some of at different times, much like filtering
the row headings are missing. The unchecked rows focuses on specific data subsets.
have just been hidden from the display. To get the
data back, open the filter list again and check the
unchecked entries. We can use the Standard Filter to
apply advanced filtering criteria. Suppose you want to know the names of the employees from
the Sales department who have more than two years of experience.
36 Plus (Ver. 3.2)-VII

