November 25, 2013

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.
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.
text form field
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.
protect form field
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.

November 19, 2013

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:
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.
copy visible cell only
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.
copy only visible cells in spreadsheet

Download Kingsoft Office Free 2013 to create free workbooks.

How to Insert Drop-Down Form Field in Kingsoft Writer

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.
 create drop down form field
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.
drop down form field options
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.
set protect form
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:
remove form field shading
Download free Office 2013 to create drop-down form field.

November 14, 2013

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.
create chart in word
Step 2 In Spreadsheets, a default chart is displayed. The chart is based on the data in the selected area above the chart.
create chart from data
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:
select data for chart
In the Source Data dialog, delete the data range data and then click the select data for chart button in Data range box.
select data for chart
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.
select data for chart
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.

October 30, 2013

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:
change plot area background color
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.
change plot area background color
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:
change plot area background color
Figure 3 Format Plot Area in Chart Tools tab

October 28, 2013

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 paragraph layout 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.
enable paragraph layout

Adjust paragraph indent and spacing

Click on the paragraph layout icon paragraph layout 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:
paragraph layout first line indent
Adjust Before Spacing:
paragraph layout before line spacing
Adjust After Spacing:
paragraph
Adjust Left Indent:
paragraph layout left indent
Adjust Right Indent:
paragraph

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.
paragraph layout tab

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
paragraph layout

How to Set Tab Stops to adjust document layout in Writer 2013

In Office 2013, you can use tab stops to adjust text layout. Follow this article to set tab stops, or clear them in Writer 2013.

Set tab stops by using the ruler

Step 1 Select the text that you want to adjust layout. Or you can first set tab stop position and type the text later.
Step 2 Go to the horizontal ruler that runs along the top of the document, and click to insert left tab stops.
insert tab stop
Figure 1 Insert Left Tab Stop
If can not see the horizontal ruler in Writer, you can go to View tab and check ruler option.
set up ruler for tab stop
Figure 2 Enable Horizontal Ruler
Step 3 Place cursor in text where you want to insert tab stop and press Tab key in your keyboard. You will find the text is aligned according to the tab stop position.

Adjust tab stop alignment

There are four types of alignment for Tabs. You can change the alignment by double click on tab stops you've inserted to ruler and change it in the pop-up dialog. See following:
adjust tab stop position
Figure 3 Set Tab Stop Alignment and Leader
Decimal: Decimal tab stop aligns numbers around a decimal point. The decimal point in number of digits will be in the same position.
Left: Sets the left start position of text and the text will run to the right.
Center: sets the middle position of the text.Text centers on this tab stop position.
Right: Sets the right end of text.
Notes:
1. You can delete a tab stop by dragging it (up or down) off the ruler. When you release the mouse button, the tab stop disappears.
2. You can also drag existing tab stops left or right along the ruler to a different position.
3. When multiple paragraphs are selected, only the tabs from the first paragraph show on the ruler.

Add leader between tab stops

You can add dotted leader between tab stops or other formatting marks, which can be selected in the Tab stop dialog (see Figure 3). Select the leader format you'd like to use and press OK to finish.

Clear Tab stops from text

Select the line of text that you want to clear tab stop. Double click on the tab stop you want to clear and the Tab dialog box will pop up (see Figure 3). In this Tab dialog, press Clear All to remove tab stops.

October 27, 2013

How to Create Indents in Writer 2013

Want to change the distance between a paragraph and page margins but in vain? Want to get text to line up with the line above but it just never comes close to? If you have met with similar problems, you are in the right place.
In Kingsoft Writer 2013, you can use tab stops, paragraph layout, and indent marker on ruler to adjust the indent. In this guide, we will show you how to use indent marker on ruler to adjust the distance between paragraph and page margins, and line up text.
There are three types of indented paragraph:
Left (right) indent: increase or decrease the left and right indentation of the whole paragraph.
First line indent: the first line of the paragraph is indented in order to differentiate from the previous paragraph.
Hanging indent: all but the first line of the paragraph is indented
left indent marker right indent marker
hanging indent marker first line indent marker

Create left or right indent

Step 1 Enable horizontal ruler in Writer. Go to View > Ruler to enable ruler.
enable ruler in writer 2013
Step 2 You will see indent markers on the horizontal ruler.
If you want to change the indent of multiple paragraphs, highlight the paragraphs first and then place cursor on Left Indent or Right Indent marker and drag it to a new place.
hanging indent in writer 2013
Figure 1 Left indent in writer 2013
right indent in writer 2013
Figure 2 Right indent in writer 2013
Note: When you drag Left Indent marker, First Line marker moves together with it. An easier way to change left indent is by clicking on Decrease Indent decrease indentor Increase Indent increase indent under Home tab.

Create first line indent

To create first line indent, the steps are similar with creating left and right indent.
Highlight the paragraph(s) you want to change first line indent, then click on First Line Indent maker and drag it to a new place.
first line indent in writer 2013
Figure 3 First Line Indent in writer 2013

Create hanging indent

In a hanging indent, the second and subsequent lines of a paragraph are indented.
Highlight paragraph(s) and click on Hanging Indent marker, then drag it to a new location on the ruler.

October 26, 2013

How to Convert Text to a Table or a Table to Text in Writer 2013

In Kingsoft Writer 2013, text can be converted to a table and vice versa. Follow this guide to do the conversion.
Convert text to a table
Step 1 Separate the text with characters like commas, space, tabs and etc. Use separator characters to indicate where you want to divide the text into columns. Use paragraph marks to indicate where a new row starts.
In the following example, we separate text with commas. You can see clearly where a new column will begin after the text is converted to table.
convert text to table
Step 2 Select the text and go to Insert > Table > Convert Text to Table.
convert text to table
In the pop-up dialog, select Commas under Separate text at, and the Table size is automatically calculated with the right number of columns and rows. If you don't see the right number of columns, you may be missing a separator character in one or more lines of text.
convert text to table
Press OK. You will get the following table:
text to table

Convert a table to text

Step 1 Select the table you want to convert to text.
Step 2 Go to Insert > Table > Convert Table to Text. In the pop-up dialog, choose separator characters you'd like to use from the list, or define your own separator by entering it into the text area of Other. This separator is used to divide text into columns.
convert table to textconvert table to text
If there is nested table within the selected table, which means another table is embedded to the selected table, choose the option of Convert nested tables in the above dialog to convert it to text. Press OK.
Rows are separated with paragraph marks by default.

October 25, 2013

How to Connect Text Box, Link Text Box in Writer 2013

You can link text boxes together so that text can flow from the first text box to the next one. Connected text boxes can span multiple pages. This is quite useful when composing newspaper, magazine and similar stuff.
Use connected boxes to:


  • Continue a piece of content in another text box
  • Create columns of different widths
  • Move text from the first text box into another one

Create Text Box Link

Step 1 If needed, create a new text box.
Step 2 Click in the text box you’d like to set as the first text box.
Step 3 Click Create Text Box Link from the toolbar under Drawing Tools tab.
create text box link
Step 4 The mouse pointer changes to a pitcher. Click in the text box you want as the next. 
connect text box
This text box is now linked to the first box and text in the overflow now appears in the next box.
connect text box
To connect more text boxes, repeat steps 3 and 4.
To check which text box is linked to the current one, you can click on the border of the text box to select it, and click Next Text Box option in Drawing Tools tab. See following:
next text box

Break text box link

To disconnect two linked text boxes, select the text box with links to another one, and click Break Forward Link in the toolbar under Drawing Tools tab.
break text box link