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

or

How to save custom sort criteria/order in Excel?

Normally we can save filter criteria by Custom Views feature in Excel, but the Custom Views feature can’t reserve custom sort criteria/order. This article will introduce you the method to save custom sort criteria or sort order in Excel.

Save custom sort criteria/order with Edit Custom Lists feature

One click to backup (take a snapshot of) current workbook, and one click to restore workbook

When undoing some operations in Excel, generally you may click the Undo button repeatedly. However, this Undo feature is frequently unable to revoke operations by VBA code. Here we recommend Kutools for Excel's Track Snap utility, which can help you temporally backup current workbook with only one click and recover your workbook to any backup versions with also only one click in Excel. Full Feature Free Trial 60-day!

ad snap 1

These temporary backup versions will be removed automatically after closing the current workbook.



arrow blue right bubble Save custom sort criteria/order with Edit Custom Lists feature

This method will guide you to save the list you have sorted by custom criteria as a custom list, and then apply the custom criteria to other data easily. Please do as follows:

1. After sorting a list, please click File > Options (or Office button > Excel Options) to open the Excel Options dialog box.

2. In the Excel Options dialog box, click the Advanced in the left pane, and then click the Edit Custom Lists button in the General section. See screenshot:

doc save custom sort criteria 2

Note: In Excel 2007’s Excel Options dialog box, please click the Popular in the left bar, and then click the Edit Custom Lists button in the Top options for working with Excel section. See screenshot:

doc save custom sort criteria 8

3. In the popping out Custom Lists dialog box, go to Import list from cells box and click the Browse button to select the list you have sorted by custom criteria, and then click the Import button and the OK button successively. See screenshot:

doc save custom sort criteria 3

4. Click the OK button in the Excel Options dialog box.

So far the custom sort criteria/order has been saved as a custom list in the Microsoft Excel program. To apply this custom sort criteria to other lists, please go ahead below steps.

5. Select the list you will sort by the saved custom sort criteria, and click Data > Sort. See screenshot:

doc save custom sort criteria 4

6. In the opening Sort dialog box, specify the list you will sort from the Column drop down list, keep Values selected from the Sort On drop down list, and select Custom List from the Order drop down list. See screenshot:

doc save custom sort criteria 5

7. In the opening Custom Lists dialog box, select the custom sort criteria you saved just now in the Custom lists box, and click the OK button. See screenshot:

doc save custom sort criteria 6

8. Click the OK button in the Sort dialog box.

Now you will see the selected list is sorted by the saved custom sort criteria as below screenshot shown:

doc save custom sort criteria 7

Easily sort data by text length in Excel

Kutools for Excel's Advanced Sort utility provides us with much more flexible sorting methods: sort by text length, sort by last name, sort by absolute value, etc. Full Feature Free Trial 60-day!

ad sort by text lenght 2


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, 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 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  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, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

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.
  • Help you work faster and easily stand out from the crowd! 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.
  • To post as a guest, your comment is unpublished.
    Mount Paul · 5 months ago
    Not what I'm looking for. I sort by columns B then D then L then N. I want to save this sort so I don't have to choose B,D,L,N over and over.
  • To post as a guest, your comment is unpublished.
    Mohamed · 8 months ago
    Really thanks alot may god bless you.