Page 24 - TP_Prime_V2.2_Class7
P. 24
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 Marks Obtained in Second Term. A
drop-down list appears. You will notice that all the entries in the column are present
in the list with small checkboxes in the beginning. Click some of the checkboxes
to uncheck them.
Step 5: Click on the OK button. You will notice that the rows of unchecked data are removed
Prime (Ver. 2.2)-VII have just been hidden from the display.
from the list. You need not to worry as the data is not lost. The unchecked rows
22
Filtering data Filtered data
To get the data back, open the filter drop-down list again and check the unchecked entries.
Custom Filter
Excel also allows you to use custom filter. Suppose you want to know the names of the
students who have scored more than 80 marks in the second term. Follow these steps to
get the required information:
Step 1: Apply filters to the data.
Step 2: Click on the Marks Obtained in Second Term header to open the filter
drop-down list.
Step 3: Place your mouse over the Number Filters option. A sub-menu opens.
Step 4: Select the Greater Than option.
The Custom AutoFilter dialog box
appears.
Step 5: Enter 80 in the criteria box and
click on the OK button.
Custom AutoFilter dialog box Applying custom filter

