Page 29 - Plus_V2.2_C7_Flipbook
P. 29

Sorting data
                 The selected data will be sorted according to the names in ascending order.


                      Custom Sorting

                 In case, more than one columns are to be sorted in such a way that the first column is in ascending
                 order and if some data is same for more than one rows then the second column of such rows gets
                 sorted in descending order. You can do this in Excel using Custom Sort. To use Custom Sorting, follow
                 these steps:

                 Step 1:  Select the range of columns to be sorted.
                 Step 2:   Click on the Sort & Filter command from the Editing group under Home tab. A drop-down list
                         appears.

                 Step 3:   Click on the Custom Sort option from the drop-down list.





























                                                            Custom sorting



                                                                                        Advanced Features of Excel  27
   24   25   26   27   28   29   30   31   32   33   34