Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.3 Order and Group Cells and Ranges: Sort by Multiple Criteria Data: Sort by Multiple Criteria Sometimes, it is useful to Sort the information by more than one criteria. Say you wanted to see how much each sales rep sold by month. 7. Try it: Sort by Multiple Criteria Select the entire spreadsheet. Go to Data -> Sort & Filter ->Sort. The Order is Custom: January, February, March   Click on Add Level to add a second Row. Choose: Sales Rep The Order is A to Z.   Click on Add Level again to add another Row. Choose: Date The Order is Oldest to Newest. Click OK. Data -> Sort & Filter ->Sort-> Add Level