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:

How to Batch Convert Text to Hyperlinks in Spreadsheets 2013

Have you ever run into this problem before, when you open your Excel or Spreadsheets files, there’re tons of links inactivated, you have to select and activate each link one by one? With Kingsoft Spreadsheets, we can help to save you the trouble. You are allowed to activate multiple hyperlinks at once.

Follow the steps below to batch create hyperlinks

Step 1: Select the cell range containing the inactivated hyperlinks. The range of cells can be discontinuous.
Step 2: Under 2013 Style interface, go to Format.
Step 3: select Convert Text to Hyperlink from the drop down list to finish.

What kind of hyperlink or url can be activated?

A URL containing a protocol, such as HTTP, FTP, or FILE, a Web server or network location, a path and file name, and you can also activate an Email Address. The following illustration defines the parts of the URL:
1. Protocol used (http, ftp, file) such as:
http://example.kingsoftstore.com/index.htm
file://ComputerName/SharedFolder/FileName.htm
2. Web server or network location, such as:
www. Kingsoftstore.com
3. Email address such as:
support@kingsoft.com

Introducing Writer Wednesday

Kingsoft Writer - Helping authors get it done since 1995.

While no two writers are the same, they all have one thing in common - needing a place to record their thoughts. Whether it be behind a keyboard or jotting down handwritten notes, every author has their own formula for success.

While the Kingsoft Office suite can be used for a myriad of tasks, writing is undoubtedly at its core. With Kingsoft Writer, authors can craft their next masterpiece faster and more efficiently than ever before. Whenever the moment strikes, let Writer be your right-hand man (or App, for that matter).

Because we get how challenging a writer’s job can be, we want to celebrate the authors of the world with a dose of weekly writing wisdom. Check out our Facebook page every Wednesday, where you will find a new quote from our favorite authors (hand picked by our very own editorial team).

Have a suggestion? We’d love to hear it. Leave us a comment in the thread below, or send us a message on Facebook.

Good luck fellow novelists, bloggers, journalists, story writers, and poets - may your creativity know no bounds and may Writer always be by your side.

"Love looks not with the eyes, but with the mind" - William Shakespeare 

How to Batch Convert Text to Hyperlinks in Spreadsheets 2013

Have you ever run into this problem before, when you open your Excel or Spreadsheets files, there’re tons of links inactivated, you have to select and activate each link one by one? With Kingsoft Spreadsheets, we can help to save you the trouble. You are allowed to activate multiple hyperlinks at once.

Follow the steps below to batch create hyperlinks

Step 1: Select the cell range containing the inactivated hyperlinks. The range of cells can be discontinuous.

Step 2: Under 2013 Style interface, go to Format.

Step 3: select Convert Text to Hyperlink from the drop down list to finish.

What kind of hyperlink or url can be activated?

A URL containing a protocol, such as HTTP, FTP, or FILE, a Web server or network location, a path and file name, and you can also activate an Email Address. The following illustration defines the parts of the URL:

1. Protocol used (http, ftp, file) such as:
http://example.kingsoftstore.com/index.htm
file://ComputerName/SharedFolder/FileName.htm

2. Web server or network location, such as: 
www. Kingsoftstore.com

3. Email address such as: 
support@kingsoft.com

WIN a Kindle Fire HDX 8.9" Tablet!

This Valentine’s Day we’re sharing the love and giving away two (2) Kindle Fire HDX tablets!  

To enter the #LoveKSO Sweepstakes, simply 'Like' Kingsoft Office on Facebook and tell us briefly why you LOVE using Kingsoft Office at home, work, on the go, or wherever your heart may take you! Submit your entry in the form below. 

                   

The Kindle Fire HDX 8.9" 16 GB tablet is the choice tablet for productivity, gaming and surfing the web. Its sleek design and awesome array of features make it a great companion for everyday use. Did we mention this is one of our favorite devices for using Kingsoft Office on the go?

To enter, submit your response by Thursday, February 13, 2014 at 11:59pm PST. Winners will be randomly selected by ShortStack app and announced on Friday, February 14, 2014 at 12:00pm PST on the Kingsoft Office Facebook page.

Good luck!  

See complete sweepstakes rules here. No purchase necessary. Giveaway open to US residents 18 years or older. Sweepstakes ends February 13, 2014 at 11:59pm PST.

Kingsoft Office is on Instagram!

Today we are excited to announce the launch of Kingsoft Office on Instagram! Follow us on Instagram @Kingsoft_Office for exclusive product updates, giveaways, news and fun behind the scenes insights. Be the first to know what we are up to, and how we are working to bring you the best free office suite on the market. 

We will also be periodically hosting contests, giveaways and other exciting online events exclusive to our fans.
Hint: We’ve got a big announcement coming up that you won’t want to miss!  


Be social! 

We love our fans and enjoy seeing how you use Kingsoft Office. Share your Kingsoft Office moments with us using the hashtag  #KingsoftOffice and we’ll be sure to give you a shout-out and some KSO love. Your photo might even be featured on Kingsoft’s Instagram or Facebook page!  

See you on Instagram!

Stay in the know - follow us on Twitter, like us on Facebook, and follow us on Instagram. 

How to convert Office documents into PDF files

PDF stands for Portable Document Format. It is a format widely used by people around the world to store and view data. Kingsoft Office (Free Office, Professional Office) offers a built-in PDF converter to convert your office documents into the PDF format - this means you can convert Word files to PDF, Excel files to PDF and PowerPoint files into PDF. This built-in PDF function is totally FREE, and highly compatible with all versions of Microsoft Office files.

Why use Kingsoft Office to convert PDF

The main advantages of this free PDF converter include the fact that it is built-in, which means you do not need to install additional software. You just open and edit your documents using Kingsoft Office, and by clicking the shortcut option, your Word, Excel, or PowerPoint files will be exported to the PDF format. It means you possess both the office software and the PDF converter simultaneously, and completely for free.

Secondly, it is secure. The generated PDF files cannot be edited by anyone else, and it even offers an encryption function to better protect your PDF files.

Thirdly, it is small. When you convert an existing document into a PDF file, its size will automatically shrink without losing any quality. Best of all, the PDF converter is highly compatible with Microsoft Office, and it can handle all Microsoft Office files such as DOC, XLS, PPT, etc., meaning you can directly convert Word, Excel and PowerPoint files to the PDF format.

Steps to converting Word/Excel/PowerPoint files into the PDF format

Follow these guide articles to convert Word/Excel/PowerPoint to PDF:

How to Convert Word to PDF for Free in Kingsoft Writer 2013
How to Convert Excel to PDF for Free in Kingsoft Spreadsheets 2013
How to Convert PowerPoint to PDF for Free in Kingsoft Presentation 2013

Open Multiple Office Files in Tabs with Kingsoft Office Tab feature

Much like a modern web browser which allows a user to open multiple web pages as tabs under the same window, Kingsoft Office (Free Office, Professional Office) tab feature offers users the same luxury for word documents, spreadsheets and presentations.

Advantages of Kingsoft Office tab feature

Common Office suites such as Microsoft Office and OpenOffice force users to open a new window every time they want to start a new document, this has a tendency to create a cluttered desktop and in some cases even impacts a user's decision whether or not to create a new document. Kingsoft Office's tab feature eliminates the problem of having too many documents / workbooks / presentations open at one time, allowing a user to conveniently switch between documents in one window by pressing the shortcut key (Ctrl+Tab).

Save time by using tabs

The ability to create document tabs not only allows the user to easily see what documents they have opened but also, most importantly, saves the user time and ultimately allows the user more time to spend thinking about what to write rather than where to find a certain document.

Organize tab orders

Users can organize the order of tabs by clicking and dragging a document tab to its desired location, giving the user control on how to prioritize tabs based on each ones' importance.

Close office tab by double clicking

Kingsoft Office's tab feature is built to save the user time, quickly close the window by double clicking on the desired tab or create a new blank document by right-clicking, pressing the shortcut key (Ctrl+N) or even pressing the tab for a new page as you would on a normal browser.

Save all tabs in one click

Right clicking on the tab allows some quick functions including Close Window, Save, Save As, Save All, Close Other Windows and Close All, which is a more practical way of saving work, it avoids a situation where a user is not sure what documents are open and may have to re-check or in rare circumstances save the document under the wrong name.

The interface Kingsoft Office offers is for the best convenience of the user and this feature alone saves time, has improved functionality and usability compared to other less innovative office suites. It eliminates everyday problems that a user may encounter when working with other word processors, spreadsheet software and presetation programs like Microsoft Word, Excel and PowerPoint.

How to Restrict Formatting Editing in Writer 2013

In the latest Kingsoft Office 2013, you are allowed to set Restrict Editing permission for a document, so that others can only edit a specified range of content in it.

Take the following steps to restrict permission to edit documents in Kingsoft Writer 2013.

Set restrictions on editing

Step 1 Open a document with Kingsoft Writer 2013
Step 2 In 2013 style interface, go to Review tab > Restrict Editing . In Classic interface, go to Tools > Restrict Editing.

Step 3 In the pop-up Restrict Editing Panel on the right, select the check box before Limit formatting to a selection of styles. Click Settings button.

Figure 1 Restrict editing of formatting

Step 4 The following dialog pops up after pressing Settings button. In the left style list, choose the styles you'd like to prevent from editing (hold Ctrl to select multiple styles), and then click on Limit. You will find that the selected styles are moved to the restricted style list on the right.

Figure 2 Add styles to restriction list

Press OK to apply the changes. The following dialog will prompt for you to remove formatting that are not allowed. If you do not want to remove the formatting, press No.

Figure 3 Choose whether to remove formatting

Step 5 In the Restrict Editing panel, click Start Protection button. Then in the Start Protection dialog, enter password and press OK.

 

Figure 4 Start Protection with password

All is done. The restricted formattings are no longer shown in the toolbar, and other will not be able to apply Heading 1, Heading 2, and Heading 3 to the document text.

Remove restrictions on editing

To remove restrictions on editing, simply go to Restrict Editing panel on the right, and click Stop Protectionbutton.

How to Protect Formula in Worksheet in Spreadsheets 2013

Sometimes you will need to protect certain cells in your spreadsheet which has formulas, to avoid accidental changes but allow editing of other data cells. You can set a password to protect only the locked cells but allow users to select and edit unlocked cells. Follow these steps:

Protect sheet formula

Step 1 Open the workbook you want to protect.

Step 2 Select the cell range you want to protect.

Step 3 Right click on the selected cells, and click on Format Cells in the context menu. See following:

Step 4 In the Format Cells dialog box, go to Protection tab and select the two check boxes of Locked andHidden. Then press OK. See following:

Step 5 Go to Review tab and click Protect Sheet button. It will ask you to enter password (optional) to protect the sheet. In the option list, select Allow all users of this worksheet to: Select unlocked cells.

Step 6 Press OK to finish setting.

In this way, you will find that the cells which are protected could not be selected, but others can be selected and edited.

Unprotect Sheet

In case you want to edit formulas in the workbook, you need to enter password to unprotect the worksheet.

To cancel protection of the sheet, simply go to Review tab, and click Unprotect Sheet.

You need to enter the protection password in the pop-up box to cancel protection.

How to Search and Replace Specific Formatting in Writer 2013

In the latest Kingsoft Office 2013, you can search and replace or remove text formatting using Writer. Press Ctrl + F to find and replace specific formatting in the document.

Find and replace specific formatting

Step 1 Press Ctrl + F in Writer 2013 to open the Find and Replace dialog.

Step 2 In Find and Replace dialog, do the following:

1. To search for text without specific formatting, enter the text in Find what box.
2. To search for text with specific formatting, enter the text in Find what box, click Format, and then select the formats you want.
3. To search for specific formatting only, delete any text, click Format, and then select the formats you want.

For example, to find and replace text with specific font format, enter the text in Find what box, and clickFormat > Font ...

Figure 1 Find and Replace Formatting

In the Find Font dialog, select the font style you want to find and press OK.

Figure 2 Find Font

In Replace with box, enter the text you want to use, and click Format > Font... In the Replace Font dialog, select the font style you want to replace the existing formatting with, and finally, press OK.

Figure 3 Replace Font

Press Find Next or Find Previous to highlight matched text and then press Replace button.

Figure 4 Replace Specific Formatting

Step 3 Click Close to close Find and Replace dialog.

Beside Font style, you can also find and replace other formatting like paragraph (spacing, indent and etc), tabs, style and highlight (see Figure 1). Follow the above steps to replace these formatting.

How to Filter an Spreadsheet Table by Color

In Kingsoft Spreadsheets (9.1.0.4480, 9.1.0.4490), if you have applied different colors to the data or different cell colors, you can filter the data by these colors.

Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table. Once you have filtered data in a range of cells or table, you can either reapply a filter to get more accurate data, or clear a filter to redisplay all of the data.

Filter by cell color, font color

Follow these steps to filter data by cell color / font color.

Step 1 Open a worksheet with Spreadsheets 2013.

Step 2 Select the range of cells you want to filter.

Step 3 Go to Home or Data tab, click on Autofilter.

Step 4 Click on the drop-down arrow in each cell of the first line in the selected range. In the autofilter option dialog, click on Filter by Color.

You can either filter the data by cell color or font color, in case you have formatted the cells by both cell color and font color.

Click one color from the above font color and cell color list. For example, select the font color of Red. You will see the data is filtered like below:

Remove Color Filter

If you want to remove the color filter you have applied to the worksheet data, follow these steps to clear the filter from the worksheet.

Step 1 Click on the autofilter icon in the column header.

Step 2 In the autofilter option dialog, click on Clear.

The filter is removed. If you want to reaply the filter, please go to Home or Data tab, click on AutoFilter option and choose Reapply from the drop-down list.

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.