How to Print Document Background Color in PDF using Kingsoft Writer 2013

In the latest Kingsoft Office 2013, you can export the background color together with the document content to PDF. Take the following steps to add background color to your document and export it to PDF.

Apply Background Color to Word Document

Step 1 Launch Kingsoft Writer 2013.

Step 2 Under 2013 style interface, go to Page Layout > Background, and then select a color for your document background. Under Classic interface, the background function can be found in Format > Background.

Figure 1 - Background Color function under 2013 style interface

The color will be applied to your document background. You can also choose a color from the color pallette by click on More Fill Colors.

Tips:

You can also apply gradient effect to the color you have applied to the document background. Click onGradient in the drop-down option list as seen in the above screenshot, and choose a fill effect in the pop-up dialog. You can choose colors, transparency, and shading styles. Press OK to apply it to the document.

Figure 2 Background color fill effect

Export document background color in PDF

Under 2013 style interface, go to Save as > Export to PDF to convert the document to PDF. After the PDF process is completed, you can open the PDF file to check the background color.

Want to try it now? Download Office Free 2013 to try it out.

How to Replace Duplicate Breaks in Document Using Writer 2013

When use Kingsoft Writer 2013 to edit document, there are sometimes many unnecessary breaks in the document. For example, you may not have used the formatting options in Writer to specify the spacing between paragraphs or lines of text. Instead, you may have inserted extra returns. In this case, you don't have to scroll through the document to delete the breaks one by one manually. There is an easy way to remove duplicate page breaks. Follow these steps to remove extra paragraph breaks.

Find and Replace duplicate paragraph breaks

Step 1 Press Ctrl + H to open the Find and Replace dialog box.
Step 2 In the Find what box, enter ^p^p (two paragraph marks).
Step 3 In Replace with box, enter ^p.
Step 4 Click Replace All.



The duplicate paragraph marks will be replaced with one. You can also find other characters and replace them.

Find and Replace duplicate line breaks

If you copied the text from the Internet, there might be too many line breaks. To replace manual line breaks with paragraph breaks, follow these steps:
Step 1 Press Ctrl + H to open the Find and Replace dialog box.
Step 2 In the Find what box, enter ^l (manual line break).
Step 3 In Replace with box, enter ^p.
Step 4 Click Replace All.

How to Insert Column Break to Document Using Writer 2013

In Writer 2013, if you have formatted your text in columns, the text will flow automatically from one column to the next. However, you can also insert column breaks manually, so that text after the break will flow to another column.

Create Columns

Step 1 Open a document in Kingsoft Writer 2013
Step 2 Under 2013 interface, go to Page Layout > Column and select number of columns you'd like to divide to text to.




For example, select Two from the Columns list. The text will be divided into two columns.

Insert Column Break

Step 1 Place your cursor where you want the column to break.
Step 2 Under 2013 style interface , click Page Layout > Breaks. A menu with options will appear; click Column Break. Under Classic interface go to Format > Columns to choose column number in the pop-up dialog.




Under Classic interface, go to Insert > Break > Column Break.



After inserting column breaks manually, the text in the document shows like this:

How to Match Gridlines and Typed Text in Kingsoft Writer

Enable Gridlines feature under View tab in Kingssoft Writer. Then write several lines, gradually you will find that the gridlines and the text you’ve typed do not match. You think this is a bug of Kingsoft Office? No, it’s not. You just need to change the setting to match gridlines and the text. Please follow the guide below:

1. Go to Page Layout > Settings > Document Grid. Select Specify line grid only and hit OK.

2. Go to Page Layout > Settings > Document Grid once again. Click Drawing Grid to bring the dialog box. Then uncheck Vertical Every box and hit OK.

3. Then you will see that gridlines and typed text are matched in Writer, as shown in the following:

How to Set Print Areas and Print Titles on a Worksheet

This article will guide you through the process of setting print areas and print titles in a worksheet using Spreadsheets 2013.

If a worksheet contains more than one page, you can print row and column headings or titles on every page to make the page data properly labeled.

Set print area

Step 1 Select the worksheet range that you want to print.

Step 2 Under 2013 style interface of Spreadsheets 2013, go to Page Layout tab, click Print Area. Select Set Print Area.

Figure 1 Set Print Area

Set print titles

Step 1 Select the worksheet range that you want to include titles when print.

Step 2 Under 2013 style interface of Spreadsheets 2013, go to Page Layout tab, click Print Titles.

Step 3 In the Page Setup dialog that pops up, click on the select button in Rows to repeat at top area and select a title row.

Figure 2 Set Print Titles in Page Setup

Figure 3 Select Row(s) to Repeat in Every Page

Step 4 Go back to Page Setup dialog and press OK to finish setting. Now the selected row is repeated at the top of each page. In Print Preview, the pages looks like the following:

Figure 4 Repeated titles on every page of the worksheet

In the same way you can set column(s) to repeat at the left of each page.

Tips:

To show row and column headings, you can tick the check box before Row and column headings under Print in the Page Setup dialog (see Figure 2).

How to Use Paste Special to do Calculations in Kingsoft Spreadsheets

Perhaps you know that in Kingsoft Spreadsheets, you can use Paste Special to do simple calculations to the worksheet data. The calculations include add, subtract, divide and multiply. Follow these steps to use Paste Special.

Step 1 In the worksheet that you want to make the calculation (in this example, column B), enter the number you want to add, subtract, multiply by or divide by in one cell (or a column). In this example, we enter the value into column C.

Step 2 Select C2 to C8 and press Ctrl + C to copy the range to clipboard. Then select B2 to B8, and go to Home > Paste. Click on Paste button to open the drop-down function list. Select Paste Special from the list.

Step 3 The Paste Special dialog pops up. Here you can choose the operation you want to do on the selected range. For example, we choose Add and press OK to apply to the selected range in column B.

You will see that Spreadsheets adds the value you copied to the Clipboard to every value in the selected range. To do other calculations, simply select from the operation list.

How to Set Different Page Orientation in Kingsoft Writer

In some special cases, people need to set different page orientation in one document. With simple page break setting in Kingsoft Writer, you can easily achieve this. Now follow the tutorial to get more office tips.

For example, there is a file with 3 pages. You want to set page 2 to landscape orientation while the other 2 pages stay portrait orientation.

Step 1: Put your cursor at the end of page 1. Go to Page Layout > Breaks > Next Page Section Break (see screenshot below). Then your cursor will move to the beginning of page 2. In this way page 1 and page 2 are break into two sections.

Step 2: Put the cursor at the end of page 2, repeat step 1 to break page 2 and page 3. Then you can begin to set different page orientation.

Step 3: Put the cursor at any place of page 2. Go to Page Layout > Orientation > Landscape. Then you will find page 2 is in landscape mode while the rest pages maintain the portrait page orientation. See screenshot:

Note: If there are too many lines in page 2, when you change page 2 to landscape orientation, there may not have enough space for all lines, then page 2 will turn to 2 pages. The two pages will have the same page orientation.

How to Activate Kingsoft Office 2013?

To activate Kingsoft Office 2013, you need to purchase a product key first. When you purchase our product and complete the payment, you will receive an email confirming your order with a license code. The code is composed of five groups of number and letter mix, which are connected with hyphens. One product key can be used to activate three PCs.

Install Kingsoft Office 2013 and Activate

If you have not installed Kingsoft Office 2013 yet, you can download the latest version here: Download Office Professional 2013.
Run the installer and follow the instructions in the wizard to start installing Kingsoft Office Professional 2013 to your computer.
In the third step of the installation wizard, enter the product serial number you have purchased.


Press Next in the following steps. After the installation is completed, your office 2013 is succesfully installed and activated.

Add serial number to Office 2013 Product Management Center

If you already have Office 2013 free trial version installed, then simply open one of the three Office components: Writer, Spreadsheets or Presentation, and then click Help button to open Product Management Center. Click Add to enter your product key and click OK to finish.


The product key will be recorded as Not limited.

How to Insert Text Form Field in Writer 2013

In Writer 2013, you can add form fields to your word document, and also lock the form to protect other content in the form from deleting or editing.

Insert Text Form Field

Text form field is useful for formal documents which are created for distribution purpose. People who receive this document can easily fill out the form by the suggestions in the text form field. Follow these steps to insert text form field.

Step 1 Open the document you want to insert text form field with Writer 2013.

Step 2 Place the cursor in a desired location in the document, and click on Insert tab. Find Text Form Fieldoption and click on it. In this example, we replace the text of [Street Address] with a text form field.

Figure 1 Insert Text Form Field

Step 3 The text form field is successfully inserted. You will see that the text form field displays as a gray area. Double click on the gray area to bring up Text Form Field Options dialog.

Figure 2 Set Text Form Field Properties

In this dialog, you can set the default text shown in the text form field and its case. This can tell readers what content should be filled in.

Step 4 Press OK. Now do the same with other parts of the document and save it.

Text form field is successfully created.

Note: Add shading to text form field will help readers easily recognize it as a field (see Figure 1).

Protect Text Form Field

To prevent others from editing the form, you can protect the form by locking it.

Step 1 Open the form document with Writer 2013.

Step 2 Go to Insert > Protect Form (see Figure 1). Click on Protect Form to lock the form. Then you will see that only the form fields can be edited. And on the menu bar of Writer, most options are grayed out.

To protect the form fields with a password, please go to Review > Document Protection. Click on Document Protection option and in the dialog that pops up, select Form fields and enter a password. Then press OK to finish.

Figure 3 Protect Form Field with a Password

To remove the password, go to Review and click on Remove Protection, and enter the password to remove it.

How to Copy only Visible Cells in Spreadsheets

When working with workbooks, sometimes there are hidden cells or columns. You have the option of copying all the cells or only the visible cells. By default, Kingsoft Spreadsheets copies all cells including hidden ones. If you want to prevent the hidden cells from being copied, follow the steps in this article to copy visible cells only. See how to hide rows or columns in Spreadsheets.

In default, hidden cells are copied:

Change Spreadsheets to copy only visible cells

Step 1: Select the data range you want to copy.

Step 2: Press Ctrl+G and then the Go to dialog box shows up.

Step 3: Select Visible cells only and click Go to.

Step 4: Copy data and paste. Thus the data won’t contain the hidden rows or columns.

Download Kingsoft Office Free 2013 to create free workbooks.

How to Insert Drop-Down Form Field in Kingsoft Writer

In Spreadsheet, it’s easy to create a drop-down list and input date efficiently. But how can achieve the same effect in Writer tables? Here is a guide to teach you how to insert drop-down form filed in Writer.

Step 1: Place the cursor in the cell and click the Drop-down From Field option under Insert tab. Then a gray area(form field) will appear in the cell.

 

Step 2: Double click the gray field to bring up the Drop-Down Form Field Options dialog box. Click Add in the Item in Drop-down list box to enter and edit relevant information. Then check the Drop-down Enabled box.

Step 3: Copy the already-set form field to other cells in this column. Select Protect Form button, cells without form field will be locked. Now, when click the cells with form field, you will see a drop-down list.

Note:

1. When you turn to edit other cells without form field, you have to click the Protect Form button again to set the locked cells free to be edited.

2. When the form field is created, there will be gray shading in the cell, which will appear when printing. To remove the shading, just click the Form Field Shading button as shown:

Download free Office 2013 to create drop-down form field.

How to Create Chart in Document with Writer 2013

You can create a chart in document with the data in a spreadsheet file. The chart is edited in Kingsoft Spreadsheets.

To create a chart based on the spreadsheet data, take the following steps.

Step 1 In Writer 2013, go to Insert > Chart. Kingsoft Spreadsheets is opened automatically.

Step 2 In Spreadsheets, a default chart is displayed. The chart is based on the data in the selected area above the chart.

Step 3 To plot different data to the chart, you need to enter your own data in this workbook, or open an existing workbook. To select the new data, click to highlight the chart, and go to Chart Tools > Select Data. See below:

In the Source Data dialog, delete the data range data and then click the  button in Data range box.

Then on the worksheet that contains your data, hold Ctrl and select the data area (with the labels) you want to plot in the chart. Press Enter to finish.

The chart is plotted with the new data. Press Ctrl+S to save the spreadsheet file and the new chart is successfully inserted to Writer. You can close Kingsoft Spreadsheets and continue editing the document.

How to Change the Plot Area Background Color in Spreadsheets 2013?

In Spreadsheets 2013, you can insert chart in spreadsheet to show data in a graph, in which data is represented by symbols, like bars, lines, or slices.

A chart is composed of these parts:

Chart Area
Legend
Plot Area
Category Axis
Value Axis
Value Axis Major Gridlines
Data Series

You can change the settings of each part of the chart. In this guide, we will show you the steps to change plot area background color.

Change plot area background color

Step 1 Select the plot area of the chart. If you are not sure which part of the chart is called plot area, see the following screenshot:

Figure 1 Plot Area

Note: Be careful not to select the horizontal grid lines running through the plot area rather than the background itself.

Step 2 Double click on the Plot Area to bring up the Plot Area Properties dialog. Here you can change the border color and style, and area background color of the plot. Choose a new color for plot area and press OK.

Figure 2 Plot Area Properties

Beside the above method, you can also highlight the chart, and go to Chart Tools tab. In the list box under Chart Tools, choose Plot Area, and then click on Format Chart to open Plot Area Properties (see Figure 2) directly. See following:

Figure 3 Format Plot Area in Chart Tools tab

How to use Paragraph Layout feature in Writer 2013

From 2012 version, Writer offers a Paragraph Layout feature, which can help you easily adjust paragraph indent and spacing. This feature is available in both Free and Professional edition of Writer. Follow steps in this guide to use Paragraph Layout in Writer 2013.

Enable Paragraph Layout

By default, the paragraph layout icon  is shown on the left of the paragraph where cursor is placed. You can click on it to select the current paragraph you are editing. If you can not see this icon, go to Home tab and click on Show/Hide Paragraph Layout icon to enble it. See following screenshot.

Adjust paragraph indent and spacing

Click on the paragraph layout icon  to select current paragraph. You will see the paragraph background color turns grey. Then you can use the mouse to drag the arrow on each side to adjust spacing and indent. 

Adjust First Line Indent:

Adjust Before Spacing:

Adjust After Spacing:

Adjust Left Indent:

Adjust Right Indent:

Adjust line spacing and other settings

When paragraph layout icon is on, the Paragraph Layout tab will be activated. You can see this tab on the program toolbar. For line spacing and other settings of the selected paragraph, you can go to the Paragraph Layout tab to apply them. For example, you can set Tight or Loose line spacing, text alignment, and styles to the paragraph. After applying all desired styles, simply press the close button on the top right to exit Paragraph Layout.

Reset paragraph format

When you want to clear the format you have set to the paragraph, click on the arrow of Paragraph Layout icon and select Reset Paragraph Format. And all the formatting will be cleared. You can also hide Paragraph Layout icon by clicking on Hide Paragraph Layout Icon.