Page 22 - Trackpad_V1_Book 7_Flipbook
P. 22

To sort the data, follow the given steps:


                                                                          2  Click on the Sort & Filter command.



                                                                                                3  For ascending order,
                                                                                               select the Sort Smallest
                                                                                               to Largest option  and
                                                                                               for descending order,
                                                                                               select  the  Sort Largest
                                                                                               to Smallest 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 the 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   Trackpad (Version 1.0)-VII
   17   18   19   20   21   22   23   24   25   26   27