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.

How to Use the Document Map in Kingsoft Writer 2013

The Document Map in Writer 2013 helps to easy navigate in long documents. You can jump around your document by different levels of headings.

How to show Document Map?

To view Document Map under Kingsoft Writer 2013, click View menu and click Document Map button, and the button is highlighted. The Document Map is shown on the right by default. If you want to show the pane on the left, click on the arrow under Document Map button, and select Place on Left.

NOTE: To make full use of the Document Map, you must format the headings in your document using the built-in headings styles. The document outline on the Document Map is generated using the built-in headings in your document, which ranges from Heading 1 to Heading 9.

How to Set Document Map Levels

You can select which heading level you want to display on the Document Map pane by clicking Show Level button on the bottom of the pane. In the above example, Level 1 is selected, so only the outline with Heading 1 style is shown. If you select Level 2, then all Heading 1 items display expanded to only show Heading 2 items. Any headings under Heading 2 are collapsed and do not show. Click on any heading in the outline to quickly jump to that section of your document.

You can also expand or collapse the headings using the plus and minus signs to the left of the headings.

Conclusion: The Document Map allows you to easily navigate in a long document, and also can show where your cursor is in your documents. While you scroll through the word document, the current heading is highlighted in the Document Map.

How to Enter Same Information for Multiple Cells in Spreadsheets

When you use Kingsoft Spreadsheets to make worksheets, sometimes you might need to enter the same information into multiple different cells. What did you do in such circumstance? Type into one cell and then copy and paste into other cells? Here is a quick tip on how to enter same info for multiple cells at once.

Enter Same Information for Multiple Cells

Step 1 Select the cells into which you want to enter the same data. The cells do not have to be adjacent. You can press Ctrl to select multiple cells which are not adjacent.

Step 2 Release Ctrl key and type a piece of text, data, time or any content that you want to, but don't hit the Enter key. Instead, hold down the Ctrl key and press Enter at the same time.

Completed! Now you will see all the selected cells are displaying the same information that you have just entered.

How to select multiple cells

To Select	Do This
A range of cells	Click the first cell of the range, and then drag to the last cell.
All cells on a worksheet	Click the Select Allbutton.
Nonadjacent cells or cell ranges	Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
An entire row or column	Click the row or column heading.
Adjacent rows or columns	Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
Nonadjacent rows or columns	Select the first row or column, and then hold down CTRL while you select the other rows or columns.

How to Use Kingsoft Office Flip Add-in to Create Flipbooks in Writer 2013

Kingsoft Office Flip is a free add-in for Kingsoft Office developed by our partner Flip builder. This add-in can help you convert Kingsoft Writer documents to stunning flipbooks. To use this add-in, simply follow steps below.

Install and use Kingsoft Office Flip

Please install Kingsoft Office first, if you haven't done so.

Step 1 Download Kingsoft Office Flip from here: Kingsoft Office Flip. Double click the installer of Kingsoft Office Flip and follow the instructions in the installation wizard to install.

Figure 1 Intall Kingsoft Office Flip

Step 2 After the installation of Kingsoft Office Flip add-in is finished, launch Kingsoft Writer. You will find a new tab of Add-in is added to Writer, see below:

Figure 2 Kingsoft Office Flip add-in

Step 3 On Add-in tab, click on Options to open the following dialog box:

Figure 3 Change Kingsoft Office Flip options

You can change the flipbook type here. If you want to place the flipbook online for others to view, you may choose the *.html type. The other two types: *.zip and *.exe can be used for sharing and CD burning.

Beside output types, you can also change output path, file name and HTML title for the flipbook.

Step 4 Press OK in Figure 3 to apply the changes. Then click Convert to FlipBook on Add-in menu (see Figure 2). The converting will begin.

Figure 4 Convert to flipbook

After the converting to flipbook process is finished, you will get the following flipbook files:

Figure 5 Flipbook structure

How to Display Gridlines in Document in Writer 2013

To display the text gridlines in document in Writer 2013, follow the steps below:

Step 1 Open the View tab and select the Gridlines check box. The gridlines will be displayed on the screen.

Figure 1 Gridlines in Writer 2013

Step 2 Deselect the Gridlines check box to remove the gridlines.

Tips: To show or hide gridlines in table, select and deselect the Table Gridlines check box in the View tab to display or hide the gridlines within the table that has no borders.

How to Track Changes to Document in Writer 2013

In Writer 2013, you can use the Track Changes feature to record all the changes made to a document. It is useful when reviewing documents for co-workers.

Enable Tracking Changes option

To track the changes made in a document, follow the steps below:

Step 1 Select the text that you want to modify.

Step 2 Open the Review tab, either select the Track Changes option in the Track Changes drop-down list, or press <Ctrl+Shift+E> to enter the tracking changes mode.

Step 3 If you want to exit the tracking changes mode, select the Track changes option again in the Track Changes drop-down list.

Change Tracking Options

The steps to change tracking options are as below:

Step 1 Open the Review tab and select the Change Tracking Options in the Track Changes drop-down list. The Options dialogue box will open and you can then select the Track Changes tab as below:

Figure 1 The Track Modifications tab dialogue box

Step 2 In the Markup section, you can adjust the Insertions, Deletions, and Comments Color options.

Step 3 In the Balloons section, you can set the corresponding items.

Step 4 Select the Change User Name option in the tab and you can enter the Name, Initials, Mailing address, etc. here:

Figure 2 The User information tab

Step 5 Click the OK button to complete the operation.

How to Create Questionnaire in Kingsoft Writer

The questionnaire is a research instrument consisting of a series of questions. It has lots of advantages such as finding more true, objective, and accurate answers than other types of surveys. Companies often turn to questionnaires to gain a greater understanding of the consumer base. The biggest problem with using questionnaires for conducting research is collecting the data after they've been filled out. Tallying data is tedious and can take hours, taking time away from you or your employees.

Kingsoft Office Free 'Forms' function allows you to create e-questionnaire and send them via email to your target audience. It will easily solve the paper questionnaire cost problems and is more convenient and quick.

This article will show you how to create a questionnaire by using the Kingsoft Writer Free version. The steps are as follows:

1. After completing the content of questionnaire, move the cursor behind the answer that should be chosen.

2. On the Insert tab, first click the Check Box Form Field, and then choose Form Field Shading to cancel the shading, next click the Protect Form button. Thus, when you use the mouse to click the checkbox it will switch between the selected and not selected status. The Schematic diagram is shown as follows:

3. Whether your questionnaire requires the user to select two or multiple answers, you can use the functions of the Drop-Down Form field. Then just move the cursor to the answer you want to selected.

4. On the Insert tab, first click the Drop-Down Form Field button, a new form field will appear, then double click the from field, a Drop-down Form Field Options dialog box will pop-up.

5. In the dialog box, choose Add button to add the content that you need, if want to add more content, click the Add again to add another one, once you're finished just click OK to complete.

6. Finally, click the Protect Form button. Thus, when you click the form field, the optional answer will pop up.

How to Use Footnote and Endnote in Documents with Writer 2013

Footnotes and endnotes are used to provide modifications, comments, and references for a written document. Footnotes are located at the bottom of the current page or below the text, explaining what the text means or add further details, while endnotes are references located at the end of a document.

A footnote or an endnote contains two related parts: the note reference mark and the corresponding note text. The note reference mark appears both in the document and in the note area. You can enter note text of any length.

Insert footnote and endnote
Edit footnote and endnote
Convert footnote and endnote
Locate footnote and endnote

Insert Footnotes and Endnotes

The steps are as below:

Step 1 Place the insertion point to the place where you want the footnote or endnote mark to be located.

Step 2 Open the References tab and click the Insert Footnote/Endnote icon. The Footnote and Endnote dialogue box will open and show as below:

Figure 1 The Footnote and Endnote dialogue box

Step 3 If you want to insert a footnote, select the Footnotes option and choose the location of the footnote as Bottom of page or Below text.

Step 4 If you want to insert an endnote, select the Endnotes option and choose the location of the endnote as End of document or End of Section.

Step 5 Open the Number format drop-down list in the Format section and select a number format.

Step 6 Enter the starting number in the Start at box.

Step 7 Select either Continuous, Restart each section, and Restart each page options in the Numbering drop-down list.

Step 8 You can also enter a symbol in the Custom mark section or click the Symbol button and select a special symbol in the Symbol dialogue box.

Step 9 Click the Insert button to complete the insertion of the footnote or endnote.

Enter the text into the footnote or endnote at the bottom of the page. See below:

Figure 2 The effect of footnote

Edit Footnotes and Endnotes

If you want to move the footnote or endnote:

Step 1 Select the the footnote or endnote.

Step 2 Move the cursor over the note and hold the left mouse button. Drag the note to the new location, then release the button.

Tips: You can also use the Cut and Paste command to move the footnote and endnote.

If you want to copy the footnote or endnote:

Step 1 Select the the footnote or endnote.

Step 2 Move the cursor over the note and hold the <Ctrl> key while dragging the mouse. You can then copy the note to a new location, and insert text into the note area.

Tips: You can also use the Copy and Paste command to copy the footnote or endnote.

To delete a footnote or an endnote, select it and then press the <Delete> key. You should also delete the note reference mark in the document so that the other reference numbers can update accordingly.

Tips: To see the contents of a footnote or an endnote, double-click on the reference mark.

Convert Footnotes and Endnotes

Footnotes can be converted into endnotes, and vice versa. To do this, follow the steps below:

Step 1 Right-click the footnote or endnote.

Step 2 Open the context menu and select the Convert to Endnote or Convert to Footnote option:

Figure 3 Convert footnotes and endnotes

Locate Footnotes/Endnotes

To locate a footnote or an endnote, follow the steps below:

Step 1 Place the cursor in the text which includes the footnote or endnote.

Step 2 Open the References tab and click the Next Footnote/Endnote icon. The View Footnote dialogue box will then open and show as below:

Figure 4 The View Footnotes dialogue box

Step 3 Select either View footnote area or View endnote area and click the OK button. You can then locate the footnotes or endnotes in the document.

How to Put Page Numbers on Opposite Corners (for Books) in Kingsoft Writer

Sometimes you will need to insert page numbers, which are placed at the bottom of the page on opposite sides — as in a book, even numbers on the left, odd numbers on the right. So how can we achieve this in Kingsoft Writer?

Align page numbers at the inside/outside corner of pages

Open your document in Kingsoft Writer 2013, and click Insert tab. Find Page Numbers drop-down menu. The following page number library pops up.

 

Divide document into sections

If you have a preface and a Table of Contents part for your document, you might need to start your page numbering from the main document body. In this case, you can insert a Next Page Section Break between different parts. This can be found in Insert tab.

Then for each section, you can apply different page numbering format. You can decide whether to continue page numbering from the previous section.

How to Use Wildcards to Search for Certain Characters in Writer 2013

The Search and Replace feature built into Kingsoft Writer includes two different search methods.

Method 1 You can search for simple items such as text or special characters using the Find feature.
Method 2 You can search for text using wildcards for pattern matching and therefore is more powerful than the first one.

By using the second method you can search for very complex character sequences in your document. The following table will introduce the wildcards and their corresponding meanings.

Related articles:

Search and replace specific formatting
Use Go To feature
Find and replace text and objects

Wildcards List

Find What	Wildcards	Example	Finding Result
Any single character	?	t?p to search for the letters t and p separated by one character.	tip, type, etc.
Characters of any length	*	c*n to search for the letters c and n separated by characters of any length.	can, command, etc.
The beginning of a word	<	<(com) to search for words that begin with com.	come, command, etc.
The ending of a word	>	>(er) to search for words that ends with er.	water, writer, etc.
One specified character	[ ]	co[mn]e to search for words with a letter (either mor n) between o and e.	come, cone, comet, etc.
Any single character within a specified range	[-]	[r-t]ight to search for words that begin with eitherr, s or t. Note that the range must be sorted ascending.	right, sight, tight
Any single character outside a specified range	[!x-z]	t[!a-m]ck to search for words with the letter between t and c not from a to m.	tock, tuck
Any number of the previous character	{n}	fe{2}d to search for words feed but not fed.	feed
At least the specified number of the previous character	{n,}	fe{1,}d to search for words with at least one ebetween f and d.	fed, feed
A specified quantity range of the previous item	{n, m}	10{1,3} to search for number with one, two or three 0.	10, 100, 1000
At lease one of the previous character	@	lo@t to search for words with at least one obetween l and t	lot, loot

Use wildcards to find and replace text

Step 1 Press Ctrl + F to bring up the Find and Replace dialog box.

Step 2 If you cannot see the Use wildcards check box in the popup Find and Replace dialog box, click theMore button and then tick the Use wildcards check box.

Figure 1 Search and replace text with wildcards

Step 3 Enter one wildcard in the Find what box. For example, if you want to find "tip", "step", and "type" or similar words, you can type t?p in the Find what box.

• 1. If you want to replace what you have entered in the Find what box, click the Replace tab and then enter the text you want to use as a replacement in the Replace with box.
• 2. If you want to highlight the results, tick the checkbox before Higlight all items found in, and click Find Allbutton. You can apply font style or font color to the highlighted items.

Tips: You can group the above wildcards to search for text or special characters as you need. For instance, enter the wildcards <(pre)*(ed)> in the Find what box to search for presorted, prevented, etc.

Step 4 Press ESC to cancel the current search.

How to Merge or Split Cells and Table in Writer 2013

Knowing how to merge or split table cells can come in handy when you are working with a table. You can merge two or more adjacent cells into one cell and you can also split a cell that has been joint.

Merge Cells

To merge cells:

Step 1 Select the cells which you want to join into one cell.

Step 2 Select the Table Tools tab and click the Merge Cells icon  to combine the selected cells.

Split Cells

To split cells:

Step 1 Select the cell that you want to split into multiple cells.

Step 2 Choose the Table Tools tab, click the Split Cells icon , and open the Split Cells dialog box.

Figure 1 The Split Cells dialog box

Step 3 Enter the number of columns or rows that you prefer into the Number of columns and Number of rows insertion box.

Step 4 If you select several cells, you can select the Merge cells before split check box to combine cells before split.

Step 5 Click OK to complete the operation.

Split tables

Kingsoft Writer provides a table splitting function. There are two ways to use this function:

Split tables by the Split Table icon

You can split tables by command in the Table Tools tab:

Step1 Place the insertion point in the cell that you want to split and go to the Table Tools tab.

Step 2 In the Table Tools tab, click the Split Table icon, and select Split Table by Row or Split Table by Column option in the drop-down list.

Split tables by the context menu

Follow the steps bellow:

Step 1 Place the insertion point in a cell.

Step 2 Right-click and select Split Table option in the context menu. Choose Split Table by Row or Split Table by Column option based on your requirements.

Tips: You can choose the Split Table by Row option only by selecting a certain row in the table and choose the Split Table by Column option only by selecting a certain column in the table.

Figure 2 Select a row to split table