Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - 2612_Digimind
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   Premium Edition-VII

| 19 20 21 22 23 24 25 26 27 28 29 |