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

        2881 results for All

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

        2881 results for All

        How to set header and footer in odd and even pages respectively

        How to set header and footer in odd and even pages respectively

        03:08

        How to set header and footer in odd and even pages respectively

        What can we do if we want to set the header and footer in odd and even pages respectively? Take this article as an example. Double-click the header of the home page, and click the Header and Footer Options in the Header/Footer tab, then you will see a pop-up dialog box. l Page different settings 1.Check Different first page in the Page different settings to set the header and footer of the first page separately. 2.Check Different odd and even pages to set the header and footer of odd....

        Writer 12.2K views
        How to insert objects in WPS Writer

        How to insert objects in WPS Writer

        01:53

        How to insert objects in WPS Writer

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to insert objects into the document by embedding or linking. 1. Embedding ObjectsTaking this document as an example, I want to insert an existing spreadsheet into the document to elaborate on the contents.Place your cursor to where you want to embed an object, then head to the Insert tab, select Object. A dialogue box will....

        Writer 12.1K views
        Data validation to help you limit the content of your forms

        Data validation to help you limit the content of your forms

        11:12

        Data validation to help you limit the content of your forms

        We have learned how to use the Validation function to restrict the entered content.1.To achieve this, we need to set different rules to restrict, such as the date format, text length, value range, and repeated value. 2.If the cell entry rules are restricted in advance, it is best to set up the corresponding error alert to help each other to enter in accordance with the specifications. 3.We also learned the method to create the drop-down menu and multi-level menus with the INDIRECT func....

        Spreadsheet 12.0K views
        How to add headers and footers to PDF files

        How to add headers and footers to PDF files

        01:25

        How to add headers and footers to PDF files

        An official document usually has additional information such as company name, date, page number, etc. at the top or bottom. This specific area is called Header and Footer. If you want to add a header and footer to a PDF file, do you know how to set it? Take this document as an example. Click the Insert tab, and choose Add Header and Footer. In the pop-up dialog box, we can add header and footer, set margins and page apply range. We insert the date in the middle of the footer, and there....

        PDF 12.0K views
        Quick to learn the time and dates functions

        Quick to learn the time and dates functions

        11:58

        Quick to learn the time and dates functions

        1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other

        Spreadsheet 12.0K views
        How to merge and split files

        How to merge and split files

        08:21

        How to merge and split files

        This lesson focuses on sharing common methods of merging and splitting files1. WPS Spreadsheet has 6 different merging methods, you can merge different worksheets into the same workbook, or merge different workbooks into the same workbook, and support the merging of worksheets with the same name. 2. “Merge range data” can select two regions and use the same value between them to find, just like a function, but more simple than a function. 3.WPS Spreadsheet has 3 different split methods....

        Spreadsheet 12.0K views
        How to print slides in black and white

        How to print slides in black and white

        00:53

        How to print slides in black and white

        Printing black and white slides helps to reduce printing costs and save resources. Next, I will share how to print black and white slides with you.Take this slide as an example. Click the Print Preview shortcut button at the top left of the screen.At this point, the slide shows the colored style.Click the drop-down button of Color above, and then click Pure Black and White so that the slide is set to be printed in black and white.In addition, we can also set the printing color in the P....

        Presentation 12.0K views
        How to print a table

        How to print a table

        12:23

        How to print a table

        This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

        Spreadsheet 12.0K views
        Prev 1 ... 38 39 ... 360 361 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