Page 22 - Trackpad_V5_Book 7
P. 22

To sort the data, follow the given steps:


                                                        2  Click on the Sort & Filter command.




                                                                                                3  For ascending
                                                                                               order, select
                                                                                               the Sort A to Z
                                                                                               option and for
                                                                                               descending order,
                                                                                               select the Sort Z
                                                                                               to A option.





                                         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. A Sort
                                                                                           dialog box will open.















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






             20   Pro (Ver. 5.0)-VII
   17   18   19   20   21   22   23   24   25   26   27