Provides friendly Word processing, Spreadsheets & Presentation software.

Kingsoft Office > Support for Windows Office > How to create custom lists for sorting in Kingsoft Spreadsheets 2012?

How to create custom lists for sorting in Kingsoft Spreadsheets 2012?

Release Date: 08-10-12

In Kingsoft Spreadsheets 2012, 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 2012

Step 1 Open Spreadsheets 2012 (2012 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 & Filter group > 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.