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

        1534 results for down wps office

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

        1534 results for down wps office

        Set input conditions and drop-down menus

        Set input conditions and drop-down menus

        01:54

        Set input conditions and drop-down menus

        The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....

        Spreadsheet 8.5K 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
        Hyperlink in WPS Office Spreadsheet

        Hyperlink in WPS Office Spreadsheet

        02:22

        Hyperlink in WPS Office Spreadsheet

        When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

        Spreadsheet 89.0K views
        Set the page printing area in WPS Office Spreadsheet

        Set the page printing area in WPS Office Spreadsheet

        00:47

        Set the page printing area in WPS Office Spreadsheet

        What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

        Spreadsheet 27.3K views
        Arrange tools in WPS Presentation

        Arrange tools in WPS Presentation

        01:32

        Arrange tools in WPS Presentation

        Arrange tools in WPS Presentation allow users to adjust the object layout, group objects, and rotate objects. The Arrange tools make it easier to manipulate images, shapes, and other elements. Usually, the latest created object is placed at the front of a slide.If we want to change the object layouts, here are the steps.1. Choose an object.2. Go to Home and click Arrange. 3. Choose Bring to Front in the drop-down menu. Another option to realize it is shown below.1. Select the object.2.....

        Presentation 8.7K views
        How to use Select feature in WPS Presentation

        How to use Select feature in WPS Presentation

        02:04

        How to use Select feature in WPS Presentation

        A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....

        Presentation 7.4K views
        How to use Merge Shapes in WPS Presentation

        How to use Merge Shapes in WPS Presentation

        02:45

        How to use Merge Shapes in WPS Presentation

        Merge Shapes is an important function in WPS Presentation. By using it skillfully, you can also create slides that have a strong sense of design.In short, based on the Boolean operation, Merge Shapes is the process of adding and subtracting two or more graphics. Select two or more graphics on the slide, and click the Drawing Tool tab and the Merge Shapes drop-down button.In the drop-down menu, we can see there are five options. They are Union, Combine, Fragment, Intersect and Subtract.....

        Presentation 19.4K views
        How to crop pictures in WPS Presentation

        How to crop pictures in WPS Presentation

        01:19

        How to crop pictures in WPS Presentation

        After inserting a picture in WPS Presentation, we can use the Crop tool to modify the shape and the scale of the picture and make it look better. Select the picture in the presentation to get into the Picture Tools tab, and click the Crop drop-down button.There are two different crop modes to choose from, Crop by Shape and Crop by Scale. · 1. Crop by ShapeHere, WPS Office provides us with a variety of shapes.If we want to crop the picture to a rounded rectangle, click Rectangle and sel....

        Presentation 17.2K views
        Prev 1 2 3 ... 191 192 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