WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • identify an ip address on a network

    13 results for identify an ip address on a network

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

    13 results for identify an ip address on a network

    How to insert envelopes in WPS Writer

    How to insert envelopes in WPS Writer

    02:30

    How to insert envelopes in WPS Writer

    Large enterprises will make envelopes with company addresses printed on them and mail documents to cooperative partners. If you are the HR of an enterprise, do you know how to make and print envelopes in WPS Writer? The steps are as follows:1. Insert envelopes into the word document.2. Click the Insert tab, and click the Envelopes button to pop up a dialog.3. Input the corresponding address in the Delivery address and Return Address text boxes. If we don't require the return lette....

    Writer views
    Smart use of Hyperlink in WPS Writer

    Smart use of Hyperlink in WPS Writer

    01:49

    Smart use of Hyperlink 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. Hyperlinks in the text can jump to the webpage or the specified position in the document. Today, we will learn how to add hyperlinks. · 1. Jump to to a location on the webFirst, place your cursor on where the hyperlink needs to be added, and enter the Insert tab, click Hyperlink to generate a dialogue box. Head to Existing File or Web Page on the....

    Writer views
    Edit settings in WPS Spreadsheet

    Edit settings in WPS Spreadsheet

    03:47

    Edit settings in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

    Spreadsheet views
    Multiple ways to use hyperlinks in WPS Presentation

    Multiple ways to use hyperlinks in WPS Presentation

    02:07

    Multiple ways to use hyperlinks in WPS Presentation

    When using WPS Presentation to make slides, we often need to add a hyperlink in the text to jump to a web page or jump to other parts of the slideshow. So how can we add a hyperlink in slides? · Add a hyperlink to jump to other slidesTake these slides as an example. 1. Select the text box where Introduction is located.2. Click the Insert tab, and then click the Hyperlink button.3. Click Place in this Document in the pop-up Edit Hyperlink dialog box.4. Then click Slide 4. Now a hyperlin....

    Presentation 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 can we insert page numbers in WPS Writer

    How can we insert page numbers in WPS Writer

    02:49

    How can we insert page numbers in WPS Writer

    In the process of document typesetting, adding page numbers can help us quickly retrieve and locate. So, how can we insert the page number into a document? Take this document as an example. Click the Insert tab first, then click the Page Number drop-down button. In the Built-in Style, we can choose the style according to demand. If there is no suitable page style, we can click the Insert Page Number button to set up. In the pop-up Insert Page Number dialog box interface, we can set the....

    Writer 0.5587 views
    Ctrl+E smart filling

    Ctrl+E smart filling

    02:50

    Ctrl+E smart filling

    After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

    Spreadsheet views
    Use the ROW function to mark the row number

    Use the ROW function to mark the row number

    02:04

    Use the ROW function to mark the row number

    When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

    Spreadsheet views
    Prev 12 Next
    WPS Academy
    Products
    Partners