Page 24 - trackpad v5.1 class 7 flipbook
P. 24

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.




                   22   Pro (V5.1)-VII
   19   20   21   22   23   24   25   26   27   28   29