Page 21 - TP_V5.1_C7_fb
P. 21

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:                            To remove the filter:

                                                                                       Short key

                    1  Click on the Sort                                                    Alt  +  D +   F +   F
                   & Filter command.







                     2  Select Filter                            “Break habits  such as sitting  in wrong
                    option from the                              postures slow down your typing speed and
                    drop-down menu.                              also lead to poor health.”













                                                                                         Advanced Features of Excel  19
   16   17   18   19   20   21   22   23   24   25   26