Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 20 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 20

    The list appears with the drop-down controls or the Filter switches on the right side of the column
                     headings.

                           3  Click on Filter Switch. Here, we want to see the
                          records of all the girls of the class.

                                                                                                    4  Tick the desired
                                                                                                   checkbox.

                                                                           5  Click on the OK button.

                     CUSTOM FILTERS
                     Excel also allows you to use custom filters. For example, you want to view the records where the
                     House is Ravi and the Gender is Girl. First, we will put a filter in Column D and set the Gender to
                     Girl by checking against it, and then set the House to Ravi.

                     REMOVING FILTERS

                     To remove the filter, follow the given steps:                            To remove the filter:

                                                                                           Short key

                        1  Click on the Sort                                                    Alt  +  D +   F +   F
                       & Filter command.

                         2  Select Filter                            “Breaking  habits  such  as  sitting  in  the
                        option from the                              wrong posture can slow down your typing
                        drop-down menu.                              speed and also lead to poor health.”

                                                                                             Advanced Features of Excel  19

| 15 16 17 18 19 20 21 22 23 24 25 |