Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 19 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 19

    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

| 14 15 16 17 18 19 20 21 22 23 24 |