Page 52 - KEC Khaitan C6 Flipbook
P. 52

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:










                   50   Premium Edition-VI
   47   48   49   50   51   52   53   54   55   56   57