WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to get a mailing list

    715 results for how to get a mailing list

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

    715 results for how to get a mailing list

    How to sort with a custom list

    How to sort with a custom list

    01:36

    How to sort with a custom list

    How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

    Spreadsheet 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 0.1846 views
    How to add a cover page in WPS Writer

    How to add a cover page in WPS Writer

    00:47

    How to add a cover page in WPS Writer

    WPS Writer is a terrific tool for adding a cover to your resume or report if you want them to have a great impression on others. How can we add a cover page to a document?We can turn to Cover Pages in the Section tab or click Cover Pages in the Insert tab. Click the Cover Pages button in the drop-down list, and we can see that there are different kinds of covers to choose from, including Business, Resume, Thesis and Transverse. After selecting the cover page, we can change the build-i....

    Writer views
    How to insert shapes in a worksheet

    How to insert shapes in a worksheet

    01:20

    How to insert shapes in a worksheet

    We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

    Spreadsheet views
    How to add a watermark

    How to add a watermark

    02:14

    How to add a watermark

    WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

    Writer views
    How to insert a table of contents in word

    How to insert a table of contents in word

    02:00

    How to insert a table of contents in word

    A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....

    Writer 0.1483 views
    How to insert and set a text box

    How to insert and set a text box

    01:44

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

    Presentation 0.1769 views
    How to crop the picture in a table

    How to crop the picture in a table

    01:30

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

    Spreadsheet 0.12 views
    Prev 123...8990 Next
    WPS Academy
    Products
    Partners