Page 31 - TP_Pluse_V2.2_Class_7
P. 31
Step 2: Click on the Sort & Filter command from Editing group under Home tab. A drop-down list
appears.
Step 3: Click on the Filter option from the drop-down list.
Using Filter
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 from the
list. You need not to worry as the data is not lost.
The unchecked rows have just been hidden from
the display. Filtering data
Filtered data
To get the data back, open the filter drop-down list again and check the unchecked entries.
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 second term. Follow these steps to apply filters to the data.
Step 1: Click on the Marks Obtained in Second Term header to open the filter drop-down list.
Advanced Features of Excel 29

