Page 52 - 2627_Trackpad Pro_C-6
P. 52

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:




                                                                 “Breaking  habits  such  as  sitting  in  the
                      1  Click on the Sort                       wrong posture can slow down your typing
                     & Filter command.                           speed and also lead to poor health.”





                       2  Select Filter                                  To filter the data:
                      option from the
                      drop-down menu                                Short key  Ctrl +          +
                      list.                                                           Shift        L







                   50   Premium Edition-VI
   47   48   49   50   51   52   53   54   55   56   57