Page 23 - TrackpadV2.1_Class8
P. 23

To sort the data, follow the given steps:


                                                                          2  Click on the Sort & Filter command.




                                                                                               3  Select the Sort A to Z
                                                                                              option to arrange data
                                                                                              in ascending order, and
                                                                                              select the Sort Z to A
                                                                                              option for descending
                                                                                              order.



                                                                                               1  Select a column
                                                                                              or range of the
                                                                                              data to be sorted.






                 CUSTOM SORTING
                 Even when the data is arranged in ascending or descending order, it can still be sorted again within

                 another column. For example, if Student’s mark list is sorted with respect to Roll No. column, we
                 can still sort it in the Name column. You can do this in Excel using Custom Sort. To use Custom
                 Sorting, follow the steps given below:


                                                          2  Click on the Sort & Filter command.










                                                                                                3  Select the Custom
                                                                                               Sort option.

















                                                1  Select a column or range
                                               of the data to be sorted.






                                                                                         Advanced Features of Excel  21
   18   19   20   21   22   23   24   25   26   27   28