Page 26 - TrackpadV5.1_class7
P. 26

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
                      2  Select Filter                                                  Skills
                      option from the                             “Break habits  such as sitting  in wrong
                      drop-down menu                              postures slow down your typing speed and
                      list.                                       also lead to poor health.”




                            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.








                   24   Pro (V5.1)-VII
   21   22   23   24   25   26   27   28   29   30   31