How to Create Custom Lists for Sorting in Kingsoft Spreadsheets 2013

In Kingsoft Spreadsheets 2013, you can create a custom list for sorting and filling data in your workbook.

Basic introduction to custom lists

Custom lists can be used for sorting data based on your own specified order. The custom list is stored in the program installation directory and can take effect only on this computer.

What's the difference between built-in and custom lists

Kingsoft Spreadsheets provides the following built-in, day-of-the-week, and month-of-the year custom lists.

Built-in list

Sun, Mon, Tue, Wed, Thu, Fri, Sat

Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

January, February, March, April, May, June, July, August, September, October, November, December

You can also create your own custom list, and use them to sort or fill your data in workbook. For example, if you want to sort or fill by the following lists, you need to create a custom list.

Custom list

Mother tongue, Fluent, Advanced, Intermediate, Beginning

Bachelor, Master, Doctor

Large, Medium, and Small

High, Medium, Low

Create a custom list for Spreadsheets 2013

Step 1 Open Spreadsheets 2013 (2013 interface), and go to Home > Options > Custom List tab.

Step 2 In List entries box, enter the values you want to sort by, and separate the values with comma. Then press Add button. The newly added values will appear in the Custom lists on the left. Finally, press OK.

Use custom list to sort your spreadsheet data

Step 1 Select the data range you want to sort, and go to Data> Sort.

Step 2 In the Sort dialog box, click Options to open Sort Options dialog. Select the newly added custom list from the drop-down list, and press OK. In Sort dialog box, select Sort by Academic degrees, which is the header row name of the column we want to sort, and then press OK.

Step 3 Finished. The column with the header row name of Academic degrees is successfully sorted by the custom list order we've added.

Delete a custom list

Go to Home > Options > Custom List tab, select the one you want to delete from the custom lists, and press delete button in the bottom right of the options dialog box. Please note that the built-in custom lists could not be deleted.