Download WPS Office for your device

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

You will be the amazing reporter with WPS Spreadsheet, which could be an alternative to Microsoft Excel. Mathematical equations contain a variety of number formats like symbols, scores, root numbers, and so on. It is difficult for us to enter these equations with the input method. However, with the Equation function in WPS Spreadsheet, inserting mathematical equations will no longer be a problem. Click the Insert tab at the top of the screen, then click the Equation button. Here, WPS O....

PDF is a highly compatible format that occupies little space and is easy to transfer. We often need to convert Word documents into PDF files in daily study and work. Here are the steps. Take this word document as an example.Click the Menu button and select Export to PDF. In the pop-up dialog box, click the small icon on the left of the file name to modify the file's name. We can set the output range as needed in terms of multi-page documents. To add multiple documents to convert at....

WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....

1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....