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

1. How to set the data format.2. How to enter the correct date and time formats.3. How to make number format and text format convert to each other.4. How to flexibly utilize the custom format.

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

Do you know how we can shut down the automatic numbering function? Here are three different ways to cancel automatic numbering. WPS Office is equipped with the automatic numbering function by default. When we enter the numbered text and press Enter, serial numbers will be automatically added in the next paragraph , and the Numbering button in the function area is gray.However, a lot of times, we don't need automatic numbering, so how can we solve this the problem? In this case, we....

We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

Do you know how to better protect the important PDF files? Today I will teach you to use the PDF encryption feature that can greatly enhance the security of documents. · 1. Set the open passwordIf you don't want others to view the contents of the PDF file at will, click the Protect tab and click Encrypt. In the pop-up dialog, check Set the open password. After setting the password, click Confirm.The next time we open this PDF file, we need to enter the correct password to view the ....

This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

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