WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to share dropbox with others

    394 results for how to share dropbox with others

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

    394 results for how to share dropbox with others

    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 to copy animation effects with the animation painter 

    How to copy animation effects with the animation painter 

    01:23

    How to copy animation effects with the animation painter 

    When designing slides, adding the same animation to similar text or shape elements can effectively unify the overall style of the slides. Here is how we can quickly copy animation effects with the Animation Painter tool in WPS Presentation. Take this slide as an example. In this slide, except for the first image, no animation has been added to the rest of the images. At this time, we only need to select the first image and click the Animation Painter button under the Animation tab.Then....

    Presentation views
    How to merge sheets with the same name

    How to merge sheets with the same name

    01:43

    How to merge sheets with the same name

    In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

    Spreadsheet views
    How to create a table with one click

    How to create a table with one click

    01:35

    How to create a table with one click

    Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....

    Spreadsheet views
    How to fill cells with pure colors, gradient colors, and patterns

    How to fill cells with pure colors, gradient colors, and patterns

    01:57

    How to fill cells with pure colors, gradient colors, and patterns

    When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

    Spreadsheet views
    How to enter a number starting with 0 in the Spreadsheet

    How to enter a number starting with 0 in the Spreadsheet

    01:38

    How to enter a number starting with 0 in the Spreadsheet

    The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

    Spreadsheet views
    How to save and quickly use the local templates in WPS Presentation

    How to save and quickly use the local templates in WPS Presentation

    01:43

    How to save and quickly use the local templates in WPS Presentation

    When we use WPS Presentation, in order to save time, we often use templates.Today, I will teach you two ways to quickly use the templates.1. We can save the beautiful slides we've made as templates, which can be shared with others or reused by ourselves. Take this slide as an example. We have edited it in advance using the Master Slides feature. If we need to save it as a template to share with others or use it again, just click Menu and click Save as.Select WPS Presentation Templa....

    Presentation views
    How to encrypt PDF files

    How to encrypt PDF files

    01:35

    How to encrypt PDF files

    Do you know how to better protect the important PDF files? Today I will teach you to use the PDF encryption feature that can greatly enhance the security of documents. · 1. Set the open passwordIf you don't want others to view the contents of the PDF file at will, click the Protect tab and click Encrypt. In the pop-up dialog, check Set the open password. After setting the password, click Confirm.The next time we open this PDF file, we need to enter the correct password to view the ....

    PDF views
    Prev 123...4950 Next
    WPS Academy
    Products
    Partners