Use the ROUND function to round decimals quickly 

In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

How can we create a drop-down list

How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

How to Add Caption

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

How to use the automatic numbering

We often use the automatic numbering function when editing documents, which can enrich the structure of the document and make it easier to read. How can we use this function? Take this catalog as an example. Select the content that needs to be numbered, click the Numbering drop-down button on the Home tab, and choose the style we want. To get more styles, we can click More Numbering on the Numbering drop-down button. A dialog box will pop up at this time. After selecting any of the st....

How to cancel automatic numbering

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

How to insert and set a text box

When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....

How to crop the picture in a table

Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....

How to convert numbers into percentages

We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....