Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 41 - logicode 2609 C6
P. 41

    SORTING DATA IN EXCEL

                     It is easy to maintain data in Excel as the sheet is divided into rows and columns but the data may
                     not be arranged in a specific order automatically as we enter it.

                     For such a purpose, Excel provides us with a feature called sorting. It is present in the Home tab
                     under Editing group. Sorting means arranging the data either in ascending or descending order.
                     Data can be sorted in two ways:

                       Ascending order: Arranging data in increasing order, for example, letters from A to Z, numbers

                       from lowest to highest, etc.
                       Descending order:  Arranging data  in decreasing  order, for example, letters  from Z  to  A,
                       numbers from highest to lowest, etc.

                     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:

                                                                                        Advanced Features of Excel 2021   39

| 36 37 38 39 40 41 42 43 44 45 46 |