Page 53 - KEC Khaitan C6 Flipbook
P. 53

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.




                 A Sort dialog box will open.

                           4  Click on the Add
                           Level button to add
                           another column to sort.


                            5  Click on Then by
                           down arrow in the                                         6  Click on the OK button.
                           Column section. Select
                           Name in this case.


                 Further, more levels can be added to the Sort dialog box for sorting the given data in a spreadsheet.



                           FILTERING DATA IN EXCEL

                 The feature of viewing rows of data suiting a specified selection criterion is called filtering data. Excel
                 allows us to see the important data and hide the rest data temporarily from the set of data. This
                 command is present in the Home tab under Editing group. To apply filters, follow the steps given below:


                                                                                              1  Click on the
                                                                                             Sort & Filter
                                                                                             command.


                                                                                              2  Select the Filter
                                                                                             option from the
                                                                                             drop-down list.












                                                                                         Advanced Features of Excel  51
   48   49   50   51   52   53   54   55   56   57   58