Page 20 - TP_V5.1_C7_fb
P. 20

To use Custom Sorting, follow the steps given below:


                                                           2  Click on the Sort & Filter command.







                                                                                                 3  Select the Custom
                                                                                                 Sort option. A Sort
                                                                                                 dialog box will open.



                                                                                                 1  Select a column or
                                                                                                 range of the data to
                                                                                                 be sorted.






                            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.
                  To apply filters, follow the steps given below:

                                                                                                 1  Click on the
                                                                                                Sort & Filter
                                                                                                command.

                                                                                                 2  Select the
                                                                                                Filter option.













                   18   Premium Edition-VII
   15   16   17   18   19   20   21   22   23   24   25