Page 25 - TrackpadV2.1_Class8
P. 25

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 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.









                                                                                         Advanced Features of Excel  23
   20   21   22   23   24   25   26   27   28   29   30