How to Add a New Dictionary to Office 2013 for Spell Check

Kingsoft Office 2013 now supports 2 languages for spell check purposes - English (United States) and English (United Kingdom). To add new dictionaries to Kingsoft Office for spell check, please take the following steps.

Also read: How to Change Spell Checking Language in Kingsoft Office 2013

Add new dictionaries to Kingsoft Office for spell checking

Step 1 Download your desired dictionary files from the internet.

Step 2 Unzip the dictionary files and save the dictionary folder to this path:

Under Windows 8: C:\Program Files (x86)\Kingsoft\Kingsoft Office\office6\dicts

Under Windows 7: C:\Program Files\Kingsoft\Kingsoft Office\office6\dicts

Step 3 Launch Kingsoft Office to see the changes.

Go to Review > Check Spelling > Set SpellcheckLanguage (2013 interface) or Tools > Set SpellcheckLanguage (Classic interface), and the added dictionaries are listed in the following dialog:

How to Change Spell Checking Language in Kingsoft Office 2013

Kingsoft Office 2013 allows you to change the default English (US) spell check to a different language. Currently Kingsoft Office supports two languages, which include English (United States) and English (United Kingdom). You can also add new dictionaries to Kingsoft Office 2013, see this guide: How to Add a New Dictionary to Office 2013 for Spell Check.

Take the following steps to switch between different languages for spell check.

Change spell check language in Office 2013

Let’s take Writer 2013 as example.

Step 1 Open an existing document with Kingsoft Writer

Step 2 Under Classic interface, go to Tools > Set SpellcheckLanguage.

Under 2013 interface, go to Review > Check Spelling > Set SpellcheckLanguage.

Step 3 In the Set SpellcheckLanguage dialog, choose a default language for spell check and press Set as default. 

The default dictionary is successfully changed to English (United Kingdom). You will find that Writer automatically checks spelling according to your new choice of language. 

If you need to switch back to English (United States) dictionary, simply repeat the above steps again. See this video:

How to Restrict Users to Edit in the Specified Ranges of Worksheet

Sometimes, you have to give different levels of permission to people to edit in the same worksheet. Some people may only have the right to check out the data, while others could edit and save the data. This article will guide you to realize how to limit other users to edit in the specified ranges in Spreadsheets, by usingAllow Users to Edit Ranges button.

Step 1 Open an existing worksheet and go to Review tab, click Allow Users to Edit Rangesoption. The following dialog will pop up.

Figure 1 Allow users to edit ranges in worksheet

Step 2 Click New in button in the Allow Users to Edit Ranges dialog box (see Figure 1), and the New Rangedialog box will pop up (see Figure 2). Input the title of the new range.

Figure 2 Add new range for editing

Step 3 In New Range dialog box, click the fold button in Refer to cells field to select the cell range: B3:E6 in the workbook, and click the fold button again to return to the New Range dialog box.

Figure 3 Add new range to protect

Step 4 After going back to the New Range dialog box, click OK to confirm. If you would like to allow people edit this range, then you should not set the Range Password.

Step 5 After going back to the Allow Users to Edit Ranges dialog box, click OK to return to the workbook. Click the Protect Sheet button in Figure 1.

Figure 4 Protect worksheet with password

Step 6 In the Protect Sheet dialog box, set the password for the Select locked cells and Select the unlocked cells.

Step 7 After clicking the OK button, the Confirm Password dialog box will pop up. Reenter password to proceed. Then press OK.

Figure 5 Confirm password

The protection on the sheet is active now.

Notes:

1. You should keep the password in mind, after you set it, otherwise you will not be able to reedit the workbook, and that will bring you a lot of inconvenience.

2. Besides, users could set multiple editable ranges, and you could set different passwords for different ranges. And let different authorized people edit in different ranges. For example, in the “Employee Info” workbook, you could set different editable ranges for different departments, such as Human Resource, Business, or Sales department. So that different department can only edit in their relative ranges.

How to Repeat Header Rows of Table in Writer 2013

Header rows are the first several rows in a table. When you need a large table displayed in multiple pages, the header rows should be repeated in each page.

In Writer 2013, you can repeat header rows of table in your document. Follow these steps to repeat header rows.

Repeat header rows in table

Step 1 Select the table you'd like to repeat header row. 

Step 2 Select one row or several rows as the header rows, go to the Table Tools tab and click the Repeat Header Rows icon .

Tips: Kingsoft Writer can automatically repeat the header rows of the table based on the page breaks. However, if page breaks are manually set, then it cannot repeat the header rows.

How to Apply Border and Shading to Table Cells in Writer 2013

In Writer 2013, after you insert a table in the document, you can apply border and shading styles to the table. Follow this guide to apply border and shading to table.

Insert border and shading to selected cells

You can insert different borders and shading based on your needs by the following steps:

Step 1 Place the insertion point anywhere in the table and select the Table Tools tab.

Step 2 Click the Table Properties icon and open the dialog box.

Step 3 Click the Borders and Shading button and open the Borders and Shading dialog box shown as below:

Figure 1 The Borders and Shading dialog box

Step 4 Select the Borders tab and choose Table in the Apply to drop-down list.

Step 5 Select the border pattern in the Setting section.

Step 6 Select the style of the border line, such as the double-line option in the Style section. Meanwhile, an effect figure will appear in the Preview section.

Step 7 Select the color of the border in the Color drop-down list and select the width of the border line in the Width drop-down list.

Step 8 Click OK to exit.

Figure 2 A table with a border

Apply different border for different cells

To set different border for different cells within the same table, for example to change the bottom border line of the sixth row of a table into a thicker line by the following steps:

Step 1 Place the insertion point to the left of the sixth row of the table. After the cursor changed into an arrow, click the right mouse button to select the whole line:

Figure 3 Select the cells to add borders

Step 2 Click the Table Properties icon and open the dialog box.

Step 3 Click the Borders and Shading button and open the Borders and Shading dialog box.

Step 4 Select the Borders tab and choose Cell in the Apply to drop-down list.

Step 5 Select Custom option in the Setting section.

Step 6 Select single line in the Style section, select the color red in the Color drop-down list, and select 1.5 pt for the border line in the Width drop-down list.

Step 7 Click the Bottom border button  in the Preview section, or directly click the bottom border on the previewed table.

Step 8 Click OK to complete the operation.

Figure 4 Emphasized border

How to Enter Date and Time Quickly in Spreadsheet

Here today I summarize all the ways to input date in the Kingsoft spreadsheet, either quick ways, the normal ways or the advanced ways. I'll explain them in details as following:

Enter date directly and fast

A.Use the keyboard shortcuts:

Ctrl+; for current date

Ctrl+' for current time

B.Enter in the cells directly

3/25/2013 or 3-25-2013

Enter other types of date

Use Ctrl+1 to open the Format Cells, choose Custom and enter the format you want in the Type, for example m"."d"."yyyy;@, then you can enter 3.25.2013 in the cell.

Set the date format

Like you did as above, you can set the date format in the Date option by opening the Format Cells.

Use formula to enter date

Besides the above ways to enter date in spreadsheet, you can also use formula to achieve this, and in this way you can real-time update the date.

Formula=today( )

Formula=now( )

And don't forget to use F9 to refresh it!

How to Use Style Reference Field in Writer 2013

Writer 2013 allows you to insert StyleRef field into header and footer, so that the headings will be shown in header or footer of each page.Take the following steps to use StyleRef in Writer 2013.

Related articles:

Use a style
Apply or delete a style
Create or modify a style

Style Reference Field

To use style reference Field:

Step 1 Select the Header and Footer icon in the Insert tab to edit either the document Header or Footer.

Step 2 Move the cursor to the position where you want to insert the StyleRef.

Step 3 Click the Fields icon in the Insert tab. The Fields dialog box will open and show as follows:

Figure 1 The Fields dialog box

Step 4 Select StyleRef from the Field names drop-down list; choose a style in the Field code such as Heading 1.

Step 5 Press OK to finish. The inserted field will be in the Heading 1 in reference to the dynamic content displayed on each header or footer.

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 tand p separated by one character.	tip, type, etc.
Characters of any length	*	c*n to search for the letters cand nseparated by characters of any length.	can, command, etc.
The beginning of a word	<	<(com) to search for words that begin withcom.	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 m or 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 either r,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 andc not from a to m.	tock, tuck
Any number of the previous character	{n}	fe{2}d to search for wordsfeed but not fed.	feed
At least the specified number of the previous character	{n,}	fe{1,}d to search for words with at least onee between fand 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 andt	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 the More 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 All button. 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 Print Document on Both Sides of Paper with Writer 2013

When print office documents, worksheets or presentations, sometimes there comes the need to print on both sides of the paper. Some printers support automatically printing on both sides of a page (automatic duplex printing); other printers allow you to manually reinsert pages to print the second side (manual duplex printing); and some printers do not support duplex printing at all. In Kingsoft Office 2013, you can conduct duplex printing. Depending on your printer features, you can use automatic duplex printing or manual duplex printing.

Check if your printer can print on both sides of paper 

You can check your printer manual to see if it supports automatic duplex printing. However, there is a much simpler way. Just click print button in Kingsoft Office, and in the Print dialog that pops up, look for the duplex printing information.

Set up manual duplex printing

Take Writer 2013 for example. If you want to print on both sides of paper, the steps are as follows:

Step 1 Open the document you want to print with Kingsoft Writer 2013. Press Ctrl+P to bring up the Print dialog.

Step 2 The printer in this example does not support automatic duplex printing, but manual duplex printing. In the Print dialog, we can see the option of Manual duplex. Tick the check box before that.

Step 3 Click OK to complete.

Writer will print all of the pages that appear on one side of the paper and then prompt you to turn the stack over and feed the pages into the printer again.

Tips:

Select the Collate check box to print one copy after another; deselect it and Kingsoft Writer will not print the next page until all of the copies of the previous page have been printed.
Depending on the printer model, you might have to turn and reorder the pages to print the other side of the stack.

Another way to print on both sides of the paper

Beside the above method, you can also achieve both sides printing in the following way.

Step 1 In the Print dialog, choose Print Odd pages. 

Step 2 Click OK.

Step 3 After the odd pages are printed, flip the stack of pages over, and then in the Print dialog box, click Even pages.

Step 4 Click OK. 

How to Consolidate Data by Position in Spreadsheets 2013

When you want to consolidate data by position, make sure that each range of data has the same layout. That means each range of data to be consolidated must be in the corresponding position on each separate worksheet. For example, in theData Example workbook, the three worksheets are 2011 Data,2012 Data and2013 data. We want to consolidate data in the these three worksheets and put the result in the 'Total Data' worksheet. Operation steps are as follows:

Step 1 Click the 2011 Data worksheet tab, and input the data. The other two worksheets have the similar layout of data.

Step 2 Add a new worksheet to collect the consolidated data. Click the Totalworksheet tab, and input row and column labels. Shown as follows:

Step 3 Select B3:E8 range in Total worksheet. Go Data tab > Consolidate. TheConsolidate dialog pops up.

Step 4 In Consolidate dialog, choose Function as Sum. Enter the range path in theReference box. Or click the source worksheet, and select the range of data to be consolidated. Then the range path of the original data will be displayed automatically in the Reference box. You need to add each one separately - select one cell range and press Add in Consolidate dialog box.

Step 5 Press OK to finish. You will find that the data is successfully combined to the Total worksheet.

How to Create a Drop Cap in Writer 2013

Drop caps are often used in formal articles, especially newspaper articles. Kingsoft Writer offers this function for your convenience. To insert or cancel a drop cap, follow these steps.

Create Drop Cap

Step 1 Place the insertion point where you want to insert the drop cap.

Step 2 Under Classic interface, go to Format > Drop Cap. Under 2013 interface, go to Insert > Drop Cap.

Figure 1 Insert Drop Cap

Step 3 In the Drop Cap dialog that pops up, choose a position to place the drop cap letter.

Figure 2 Drop Cap settings dialog

Step 4 Select a font for the Drop Cap. Besides, you can set Lines to drop and Distance from textas well.

Lines to drop: Choose the number of lines that the drop cap will occupy. 
Distance from text: Set the distance between the drop cap and the text.

Figure 2 Drop Cap settings

Please note that the unit for Distance from text is "mm", and you can select another measurement unit from the list. Also read: How to Change Page Margin Units and Set Default Margins in Kingsoft Writer

Step 5 Press OK to finish. If you'd like to change the drop cap effect, simply go through the above steps again.

Cancel Drop Cap

To cancel the drop cap, place the insertion point where you want to cancel the drop cap paragraph. In Drop Cap dialog box (Figure 2), select None, and click OK.

How to Apply Double Space to Paragraph in Writer 2013

In Kingsoft Writer 2013, there are two methods to change paragraph line spacing. Follow this article to change the line spacing to double lines in your document.

Change to double line spacing using Line Spacing button

No matter you use Classic or 2013 style interface, you can take the following steps to apply double line spacing easily:

Step 1 Open an existing document in Writer 2013.

Step 2 Select the paragraph you'd like to apply double spacing. Don't select any paragraph if you want to apply double spacing to the whole section or document.

Step 3 Click Line Spacing button in the toolbar and select 2.0 from the drop-down list. The line spacing is successfully changed.

Change to double line spacing under Paragraph Layout tab

Step 1 Select the paragraph(s) you want to change line spacing.

Step 2 Click Paragraph Layout button which appears to the left of the selected paragraph(s). This will open the Paragraph Layout tab in Writer.

Step 3 Under Paragraph Layout tab, enter the number of "2" in Line Spacing box and press Enter. See below:

The line spacing of the selected paragraph is changed to double line.

While you are writing, there will be a paragraph layout button double spacing on the left, in the same line with the mouse cursor, click to select the paragraph that you want to change spacing. line spacing

2. A new panel of Paragraph layout will appear in the tool bar.

3. In the Paragraph Layout tab > Line Space group, there is option for tight spacing and loose spacing. Click either one and then click "+" to increase line spacing to double lines. If you would like to use customized line spacing, you can enter the number in the line spacing box.

How to Change Default Font in Spreadsheets 2013

When you create a new workbook in Kingsoft Spreadsheets, the workbook will adopt a font style of Times New Roman, with the size of 12 as default. While, you can change this to your favourite font and size. In Spreadsheet 2013, do the following:
1. Go to > to bring up the Options window.
2. Click the General and Save tab. Choose a font style from the drop-down list and a size in the Standard font menu. Then press OK.



Then when you create a new workbook, the font size and style will apply the new settings.
Also read:

Guide for Setting Font in Kingsoft Writer

How to Change the Author Name for Documents in Writer 2013

Every time you create a new document, Kingsoft Writer will attach the author information to the document according to your settings in Writer Options. This name also appears in comments and tracked changes. To change the author name, simply follow these steps.

Change author name for new documents

Step 1 Launch Writer 2013 and go to Writer > Options.
Step 2 In the dialog that prompts, select User Information on the left. And on the right window, change the author name. You may also change Initials and Mailing address here.

Step 3 Press OK to finish.

Change author name of existing document

To change the author name of existing document, you may follow these steps.
Step 1 Open an existing document with Writer 2013.
Step 2 Go to Writer > File Information > Properties.

Step 3 In Properties dialog box, change author name to another one.

Note:
Changing author name in document property will not affect the author name in newly created document.

How to Add Color to Sheet Tabs in Spreadsheets 2013

In Spreadsheets 2013, you can apply different tab colors to each sheet tab, or the same color to all sheet tabs of your workbook. Follow these guide to add colors to the sheet tabs.

Select sheet tabs

Step 1 Launch Spreadsheets 2013, and open an existing workbook that has more than one sheets.

Step 2 Select one or more than one sheet tabs.

. To select one sheet tab, simple click on it. 
. To select more than one tabs, hold on Ctrl and select sheet tabs (can be discontinuously).
. To select all tabs, select the first sheet tab, then hold on Shift key and select the last tab. Or, you can simply right click on one of the sheet tabs, and choose Select All Sheets.

Apply color to selected sheet tabs

There are two methods to apply a color to the selected sheet tab(s).

1. Right click on the sheet tab(s) and go to Tab Color, and choose a color from the color pallette.

2. Somesimes if you have selected multiple sheet tabs, right clicking might cancel the selection. In this case, you can go to Home tab (2013 Style interface) > Worksheet > Tab Color and choose a color to apply. See following: