WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to insert grid line in excel

    494 results for how to insert grid line in excel

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

    494 results for how to insert grid line in excel

    How to set the line numbers in WPS Writer

    How to set the line numbers in WPS Writer

    01:56

    How to set the line numbers in WPS Writer

    The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

    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 insert comments in WPS Presentation

    How to insert comments in WPS Presentation

    01:41

    How to insert comments in WPS Presentation

    When using WPS Presentation, we can use the Comment feature to help us check the suggestions more intuitively. Also, this feature will not affect or modify the original content of the file. So how can we insert comments? Take these slides as an example. If we want to insert a comment on the first slide, click the Review tab above, and then click New Comment. At this time, a comment editing box will pop up in the upper left corner of the slide. Here, we can enter the comment content. Us....

    Presentation views
    How to insert pictures in Document

    How to insert pictures in Document

    02:05

    How to insert pictures in Document

    When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

    Writer 0.2452 views
    How to insert attachments in WPS presentation

    How to insert attachments in WPS presentation

    01:07

    How to insert attachments in WPS presentation

    When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....

    Presentation views
    How to insert video in WPS Presentation

    How to insert video in WPS Presentation

    01:07

    How to insert video in WPS Presentation

    When making slides, we can make the presentation look more professional by inserting video adequately in slides. So how can we insert videos?Take these slides as an example. Click the Insert tab above, and then click Movie. Here, we can choose Local Video or Link Localvideo. The main difference between them is the way of saving the video files.Please note that: if we choose Link Localvideo to insert a video, once we send the slides to other devices, WPS Presentation may not be able to ....

    Presentation 0.1239 views
    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
    How to insert calculated fields in PivotTable

    How to insert calculated fields in PivotTable

    01:06

    How to insert calculated fields in PivotTable

    Take this sales performance table as an example. We want to generate a new column, "sales commission" based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that? First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Field dialog will pop up.In the Name edit box, input "Sales commission". In the Fields area, choose Sales amount. In the Formula edit box, inpu....

    Spreadsheet views
    Prev 123...6162 Next
    WPS Academy
    Products
    Partners