Page 39 - Computer Genius Class 07
P. 39
Filtering Data
ou must ha e studied a out filtration process hich is used to separate un anted material rom a
mi ture. cel also pro ides you to filter un anted data rom a set o data.
To apply filters ollo the gi en steps
2 Click Sort & Filter command.
3 Click Filter from
the drop do n list.
1 Select the
range of columns
to be filtered.
4 Click on the arrow in front of the header
Marks Obtained to open a drop do n list.
5 Click some of
the checkboxes
to uncheck them.
6 Click on the OK button.
You will notice that the rows of unchecked data are removed from the list. You need not worry as the
data is not lost. otice the ro headings. Some o the ro headings are missing. The unchec ed ro s
ha e ust een hidden rom the display. To get the data ac open the filter list again and chec the
unchecked entries.
Advanced Features of Excel 2016 37

