Download WPS Office for your device

WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users. PDF is the abbreviation of Portable Document Format with many advantages, such as being compatible with multiple platforms, keeping original file layout, allowing file encryption and so on.So, how do we export the WPS Presentation as a PDF?Take this slide as an example, click the Tools tab above, and then click the Export to PDF button.....

Sometimes we need some preconditions to improve the validity when inputting data. Today we will learn how to set formulas as the validation condition.For example, we only need to enter the spouse's name if the marital status in column D is "married."First, select the cell area E3: E11, click "Validation" in the "Data" tab to enter the "Data Validation" dialog, where we can select "Custom" at the "Allow" drop-down box.Then, enter the formula =D3="married." It means that people can ....

When we use WPS Presentation, in order to save time, we often use templates.Today, I will teach you two ways to quickly use the templates.1. We can save the beautiful slides we've made as templates, which can be shared with others or reused by ourselves. Take this slide as an example. We have edited it in advance using the Master Slides feature. If we need to save it as a template to share with others or use it again, just click Menu and click Save as.Select WPS Presentation Templa....

When we use WPS text, sometimes we need to set colors or backgrounds for the documents. How can we achieve it? To set the background to green, click Page Layout on the taskbar, and select Page Color. Then, choose a theme color as you want. For more color, you can also click on the More Color below to customize the desired color. How can we set the picture background for a document? 1. Click Page Layout on the upper taskbar.2. Find Background, and choose Picture Background.3. Then, you&....

Sometimes there are several tables in one worksheet, and we want to add blank rows in one of the tables. How can we solve it? Take this worksheet as an example. Suppose we need to add a blank row in the left table. At this time, if we use the frequently used method, which is to select the desired range and right-click to insert a blank row, we can find that a blank row is also inserted in another table. Thus, we need to use another method to insert the blank row.Firstly, select the loc....

Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....

When processing table data, we sometimes need to export the table as an image to send the table information to others for viewing.Take this table as an example. We need to export the contents in the table as an image to send to the leader for review. Head to the Tools tab, and click Export to Picture. The exported image defaults to Long picture, and the table will export All pages by default in the pop-up dialog. You can find that the preview interface on the right is incomplete. At th....

When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....