WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2189 results for how to round down

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        2189 results for how to round down

        Use the ROUND function to round decimals quickly 

        Use the ROUND function to round decimals quickly 

        01:57

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

        Spreadsheet 23.8K views
        How can we create a drop-down list

        How can we create a drop-down list

        01:33

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

        Spreadsheet 45.1K views
        How to insert blank pages

        How to insert blank pages

        00:38

        How to insert blank pages

        After editing the document, we sometimes may want to insert a blank page in the middle to supplement related content. So how can we do that? After clicking the page, click the Blank Page drop-down button in the Insert tab. Here, we can choose Vertical Text Box or Horizontal Text Box.GIf If we want to delete a blank page, place the mouse on the blank page. Now hold down the Backspace key, and press the Delete key to delete the blank page.GIf This skill could be compatible with Microsoft....

        Writer 31.7K views
        How to Add Caption

        How to Add Caption

        01:41

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

        Writer 16.6K views
        How to add annotations to PDF files

        How to add annotations to PDF files

        02:08

        How to add annotations to PDF files

        When we read the information of certain PDF documents, sometimes we need to mark some important paragraphs or add corresponding comments to some content. Today I would like to introduce how to add annotations to PDF documents quickly. Take this PDF document as an example. Click the Comment tab, and click the Note Mode button. At this time, a blank page appears on the right side of the document body. We select the text that needs to be annotated, click the Highlight drop-down menu, and ....

        PDF 13.3K views
        How to cancel automatic numbering

        How to cancel automatic numbering

        01:45

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

        Writer 10.9K views
        How to use the automatic numbering

        How to use the automatic numbering

        02:11

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

        Writer 34.5K views
        How to add hyperlink to PDF

        How to add hyperlink to PDF

        01:42

        How to add hyperlink to PDF

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

        PDF 12.4K views
        Prev 1 2 3 ... 273 274 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube