Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2633 Trackpad Pro V5.1 Class 7
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                             “Breaking  habits  such  as  sitting  in  the
                          drop-down menu                              wrong posture can slow down your typing
                          list.                                       speed and 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   Premium Edition-VII

| 21 22 23 24 25 26 27 28 29 30 31 |