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

        2075 results for how to round down

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

        2075 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 20.6K 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 38.0K 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 9.0K 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 10.2K 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 14.0K 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 29.9K 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 27.4K views
        How to use Navigation Pane

        How to use Navigation Pane

        02:01

        How to use Navigation Pane

        Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....

        Writer 15.4K views
        Prev 1 2 3 ... 259 260 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