Office for IOS Apps List
Office for Windows Software List
- WPS Office 2016 Free
- WPS Office 2016 Beta
- WPS Office 2016 Business
- Kingsoft Data Recovery
- Writer Professional
- Spreadsheets Professional
- Presentation Professional
- Writer Free 2013
- Spreadsheets Free
- Presentation Free 2013
- Office Suite Standard
Office for Android Apps List
Tips and Guides
- How to Protect and Recovery Losing Files
- How to Use Kingsoft Data Recovery Master
- Compatible with ODF documents in WPS Office
- Difference Between WPS Office Free and WPS Office Business
- Hundreds of WPS Office Templates to Increase Your Productitvity
- How to Switch Language Interfaces in WPS Office
- How to Paste Text Without Format in Table?
- A Quick Smart Way to Fill out the Tables in Spreadsheets
- How to Paste Text Only in Table
- How to Extract All Email Addresses in One Document with A Second?
- How to Convert PowerPoint to Word document with Kingsoft Office?
- How to Insert Watermark to Documents with Kingsoft Writer?
Key Features of Office Suite
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.
|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.
|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.
OFFICE FOR WINDOWSWPS Office 2016
WPS Office 2016 Business
Multi Language Office Suite
Kingsoft Data Recovery
WPS PDF to Word
OFFICE FOR ANDROIDFree Office Suite for Android
Free Office Reader for Android
Android Office Application International
Android Office User Manual
Download ExpressWPS Office 2016 Business
WPS Office 2016 Free
WPS Office 2016 Beta
Office Suite for Android newest