Download WPS Office for your device

When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

Sort and AutoFilter can help us arrange and select data.1.We can set single condition sort and multi-condition sort, as well as create specific sorting rules on our own.2. In the part of AutoFilter, we shared some basic functions such as value filter, filter by text, date, and color, and advanced filter. In the Advanced filter, we can set "simultaneous satisfaction,'" and "partial satisfaction." We can also filter the unique data record.3. The AutoFilter function in WPS Spreadsheet....

When creating tables, we sometimes need to import data from outside, and this data often requires secondary classification processing. We now want to classify the data in the table into Name, Age and Telephone. So how can we do that?1. We select column A, click the Data tab.2. Click the Text to Columns drop-down button. 3. Then select the Text to Columns option in the drop-down menu.In the popup dialog box, we can see two options.+One is Delimited. Here, we can use symbols as the basis....

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

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....

Switching back and forth between different workbooks is inconvenient for checking data. Today we will tell you how the View side by side function can help.For example, suppose we want to check whether the data in March is identical in the Quarterly Sales and Monthly Sales sheets. Click the View side by side in the View tab. The interface will then be divided into two sections, one on the left and one on the right. The quarterly sales sheet is on the left while the monthly sales sheet i....

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