Page 54 - KEC Khaitan C6 Flipbook
P. 54
The list appears with the drop-down controls or the Filter switches on the right side of the column
headings.
3 Click on Filter Switch. Here, we want to
see the records of all the girls of the class.
4 Tick the desired
checkbox.
5 Click on the OK button.
CUSTOM FILTERS
Excel also allows you to use custom filters. For example, you want to view the records where the
House is Ravi and the Gender is Girl. First, we will put a filter in Column D and set the Gender to
Girl by checking against it, and then set the House to Ravi.
REMOVING FILTERS
To remove the filter, follow the given steps:
“Break habits such as sitting in wrong
1 Click on the Sort postures slow down your typing speed and
& Filter command. also lead to poor health.”
2 Select Filter To filter the data:
option from the
drop-down menu Short key Ctrl + +
list. Shift L
52 Premium Edition-VI

