Page 24 - C_GPT _V4 _class_7
P. 24

To sort data, follow these steps:


                                                                                                    Click on the
                                                                                                    Sort & Filter   2
                                                                                                    button.
                     Select a
                     column or
                     range of
                 1   data to be
                     sorted.













                                                       Click on the Sort A to Z (for text) or Sort
                                                   3   Smallest to Largest (for numbers) to sort
                                                       the data in ascending order.



              Custom Sorting

              In case more than one column is to be sorted in such a way that the first column is in ascending order
              and if some data is the same for more than one row, then the second column of such rows gets sorted
              in descending order. You can do this in Excel using Custom Sort.

              To use Custom Sorting, follow these steps:

                                                                                                    Click on the
                                                                                                    Sort & Filter   2
                                                                                                    button.


                     Select the
                     range of
                 1   columns to
                     be sorted.













                                                                       3   Click on the Custom
                                                                           Sort option.








                        CodeGPT (Ver. 4.0)-VII
                 22
   19   20   21   22   23   24   25   26   27   28   29