Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

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. Click for 60-day free trial!

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. Click for 60-day free trial!

ad sort by text lenght 2


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

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.

Be the first to comment.