Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


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?

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial

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?

Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

  • Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Being used by 110,000 elites and 300+ well-known companies.

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.