Page 24 - Chinmaya_C7_flipbook
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.


                                                                                      Life Skills & Values


                      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   Premium Edition-VII
   19   20   21   22   23   24   25   26   27   28   29