Page 24 - Trackpad_V1_Book 7_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 Sort & Filter command.














                    2  Select Filter
                    option from the                               “Break habits  such as sitting  in wrong
                                                                  postures  which slow down your typing
                    drop-down menu.
                                                                  speed and 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 the
                                                                                                      desired fill effect.










                   22   Trackpad (Version 1.0)-VII
   19   20   21   22   23   24   25   26   27   28   29