Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 42 - logicode 2609 C6
P. 42

    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.

                       40   Premium Edition-VI

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