Page 64 - modular4.0
P. 64

Chapter Profile
                  Follow the given steps to apply Custom sort option:

                                                                       2  Click on the Sort & Filter command.









                        1   Select  the  range
                        of columns to be
                        sorted.



                                                                                     3  Select Custom Sort option.



                                                           4  Check My data has headers
                                  8  Click on the Add     checkbox, if the selected columns
                                  Level button.           have a heading at the top.



                                                                                                7  Click on the Order
                                                                                                drop-down list and
                     5   Click  on  the  Sort  by                                               select the A to Z or Z
                    drop-down list and select                                                   to A option.
                    the column header.




                                                           6  Click on the Sort On drop-down
                                                           list and select Cell Values option.






                                9  Repeat steps 6 to 8 to
                                add more criteria.








                                                                           10 Click on the OK button.

                  Notice that if the Client Name is the same for two different rows in the Client Name column, they
                  will be sorted based on the Amount Billed column in Largest to Smallest order. This means the client
                  with the higher amount billed will appear first.







                62   Modular (Ver. 4.0)-VII
   59   60   61   62   63   64   65   66   67   68   69