How to sort data by custom list in Excel?
We can sort date in ascending order (from A to Z, form lowest to highest) or in descending order (from Z to A or form highest to lowest) in Excel easily. However, sometime you may want to sort data in a customizing order for some reasons, such as special name list, product name list, etc.
Supposing I have a sales table as the following screen shot shows. I do not want to sort the by the sales volumes, but sort the salespersons in a custom order as: Peter, Ann, Marsha, Jim, Cindy, John, and Joe. How can we sort data according to a custom list in Excel?
Please process the following steps:
Step 1: Select the range that you will sort by custom list. In this case, select the range of A2:H8.
Step 2: Click the biggest Sort button in Sort & Filter group under Data tab.
You can also click the Custom Sort item from the drop down list of Sort & Filter button under Home tab.
Step 3: In the Sort dialog box, specify the Sort by columns in the Sort by box.
Step 4: In the Order box, select the Custom list from the drop down list. See the following screen shot.
Step 5: the Custom Lists dialog box pops up, select and highlight the requiring list from the custom lists box, and click OK.
Step 6: Now you get back to the Sort dialog box, click OK.
Then it sorts the select data by the custom list immediately.
Note: the custom list you apply for sorting must has been created before. Click to know How to create a new custom list?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!