Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2626_South Point_C-7
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 |