Download WPS Office for your device

When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

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....

In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

RANK function is a statistical function that can quickly calculate the rank of a number in a list of numbers. Taking this sales table as an example, how do we rank the sales volume in the first quarter? First, we can place the cursor in cell F3, click the Formulas tab, and Insert Function button to find RANK function. At this time, the Function Arguments dialog box will pop up.Number is the number for which you want to find the rank. Ref is an array of, or a reference to, a list of num....

In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

The clever use of VLOOKUP function can help us quickly find the relevant results. It is usually used to check and match the data between multiple tables. Take this table as an example. In the table on the right, we know the "Number" and "Name" of the "Group1" members, so we are looking for the "Chemistry" scores of the members.1. Click cell J3, and click "Insert Function".2.Click "Lookup and Reference" in "Category", and choose "VLOOKUP" function.3.In the popup dialog box, we can see t....

In this lesson we have studied the following key points:1. How to create table borders and insert a diagonal line to the table header.l You can click the "Drow border" button to draw the form lines manually, or you can click the "All borders" button, which provides many border styles.l Select the targeted cell first, press the shortcut key "Ctrl+1", select "Border" >select a diagonal line border. 2. How to merge or unmerge cells.WPS Spreadsheet also provides more ways of merging cells....