Download WPS Office for your device

In WPS Spreadsheets, there are two ways of splitting sheets: Split Sheets By Content and Split Books By Sheet. First, Split Sheets By Content.Take this table as an example. We want to split this table into multiple sheets by month. Click the Data tab, click the Split Sheet drop-down button and select Split Sheets By Content. The default Split area is the whole table. Check My data has headers to make the split sheets have titles. Since we want to split the table by month, we select "Mo....

When you want to split the content based on the specific categories in the sheet, are you still disassembling and reorganizing the content one by one? The Split Sheet feature can help you. Take this sheet as an example. If we want to split this sheet into three sheets based on class 1, class 2 and class 3, what should we do? We just need to click the Home tab and click Worksheet, then click the Split Sheet option, finally choose Split Sheets By Content. In the Split area box, we can ch....

In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

1.Introduces several causes of pivot table errors.We should standardize the original table. Blank cells in fields, irregular dates format, merged cells, or numerical texts in numerical values will trigger errors.2.Introduced the basic rules of using pivot charts.PivotChart can show the data trend. The X-axis will show the fields in ROWS, while the Y-axis will present the fields in VALUES.3.Slicer can show your leader what they want to see, including fields that aren't in the PivotT....

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

In this lesson we have studied the following key points:1. How to make number format and text format convert to each other?In WPS Spreadsheets, when the number entered exceeds 11 digits, it will be automatically converted into text.Text format has the following 3 features: it is aligned to the left by default; it is unable to participate in calculation; a green corner prompt will appear in the upper left corner of the cell will. The way to convert text format into number format is as ....

By setting hyperlinks in the document, we can click them to quickly jump to the specified pages or web pages, making it more efficient and convenient for us to browse the document. Now, we can use the hyperlink function in PDF documents by joining WPS Premium. Take this thesis as an example. We need to add a corresponding hyperlink to the title in the catalog. Click the Edit tab and the Link drop-down button, select Add/Edit Link, then hold the mouse in the area where the hyperlink nee....