Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2612_Digimind
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

                      Conditional formatting allows you to automatically apply formatting to cells based on specific
                      criteria or conditions. 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 |