Page 35 - iPro_trackGPT_V5_Class8
P. 35

use Custom Sort in Excel. A custom sort allows you to sort data in a specific order that you define,
                 rather than just sorting in ascending or descending order. To use Custom Sort, follow the given
                 steps:


                                                               3  Click on the Sort & Filter command.



                        2  Click on the
                        Home tab.
                                                                                                    4  Click on
                                                                                                   the Custom
                                                                                                   Sort option.

                          1  Select
                          the range of
                          columns to
                          be sorted.






                                                                    8  Click on the Order box   5  Check My data has
                                             7  Click on the Sort   to select A to Z (for text)   headers checkbox if the
                                             On box to select Cell   and Smallest to Largest   selected columns have a
                                             Values option.        (for numbers).             heading at the top.
                    9    Click  on
                   the  Add  Level
                   button  to  add  a
                   new criteria.


                    6  Click on the
                   Sort by box to
                   select a column
                   head for sorting.









                                          10 Repeat steps 6 to 8                     11  Click on the OK button.
                                          to specify more criteria.

                 The data will be sorted according to the criteria defined.

                         Boost Bits


                   The  sorting  can  also be done  through  the  Sort &  Filter group  under  the  Data tab  by
                   selecting     and     commands for sorting in ascending and descending order, respectively.
                   To create a custom sort, click on      command.







                                                                             Spreadsheet—Functions and Charts    33
   30   31   32   33   34   35   36   37   38   39   40