Page 22 - Chinmaya_C7_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
                                                                                              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   Premium Edition-VII
   17   18   19   20   21   22   23   24   25   26   27