Page 24 - Trackpad_V5_Book 7
P. 24

CUSTOM FILTERS

            Excel also allows you to use custom filters. For example,
            you  want to  view the records where  the  House is                To filter the data:
            Ravi and the Gender is Girl. First, we will put a filter      Short key  Ctrl +          +
            in Column D and set the Gender to Girl by checking                              Shift         L
            against it, and then set the House to Ravi.










            REMOVING FILTERS

            To remove the filter, follow the given steps:





                                                       1  Click on the Sort
                                                      & Filter command.



                                                                                  21 st
                                                                               Century   #Flexibility
                                                                                 Skills
                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.”
                                                                                       -Mr. Techie



                      CONDITIONAL FORMATTING

            To apply conditional formatting to a series of data, follow the given steps:


                                                       1  Select the data and click on the
                                                       Conditional Formatting command.






                                                                                           2  Select the
                                                                                          desired option.


                                                                                           3  Choose
                                                                                          desired fill effect.









             22   Pro (Ver. 5.0)-VII
   19   20   21   22   23   24   25   26   27   28   29