Page 29 - TP_Pluse_V2.2_Class_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   The moon highlights different aspects
                                                                                 at different times, much like filtering
                 some data is same for more than one rows then the second          focuses on specific data subsets.
                 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
                 Step 4:  Check My data has headers checkbox, if the selected columns have a heading at the top.


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