How to sort text in WPS Writer

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

Custom sorting in WPS Spreadsheet

We often need to sort the data to organize the table in our work, so how can we sort the data in a table? Take this table as an example. We want to sort the Overall result of this table from largest to smallest.1. Select the cell range in the Overall result column, and click the Home tab, then click the Sort drop-down button.2. Select Descending in the drop-down menu, and then select these two options Expand the selection and Continue with the current selection in the pop-up Sort Warni....

Text to Columns: Sort data quickly

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

How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

Use subtotal feature to do statistic

The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....

Make a ranking bar chart

The bar charts use bars with the same width to indicate the amount of data. Therefore, we can compare data intuitively. By using a bar chart, it will be convenient for us to compare the differences between data.Take this table as an example. This is the data of cumulative confirmed COVID-19 cases on April 9, 2020. If we want to see the difference in confirmed cases between countries more intuitively, we can use a bar chart.1. Click any cell in the data area.2. Click the Insert tab.3. T....

Wrap text in a cell

When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....