Get WPS Office for Linux

How can we change the paper orientation and size for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice.

When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

When processing data in a Spreadsheet, we somtimes quickly need to locate the data among various data, or modify incorrect data in bulk. It would be convenient to use the Find and replace fucntion in WPS Spreadsheet. This video could be used in Microsoft Office Excel and Openoffice. Take the following table as an example, which records students’ grades on various subjects. Supposed that we want to find the E grade from the sheet. 1. Select all those ranges of cells that we want to find....

In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

After inserting the picture in the document, how can we set the text wrapping style? Take the word document as an example. This video could be also used in Microsoft Office Word and Openoffice. After clicking the picture, click the Wrap Text button in the floating toolbar to the right of the picture. We can choose a variety of text wrapping styles here. Click View more, and the Layout dialog box will pop up, which allows us to set the wrapping style more accurately.In the Text Wrapping....

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....