WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to update all fields in word

    452 results for how to update all fields in word

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

    452 results for how to update all fields in word

    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
    How to use the Arrange All function in WPS Presentation

    How to use the Arrange All function in WPS Presentation

    00:50

    How to use the Arrange All function in WPS Presentation

    We may need to refer to multiple documents when editing slides, but it is troublesome to switch back and forth. At this point, we can use the Arrange All function to display multiple documents at the same time. 1. Click the View tab and click Arrange All.2. Here we select Tile Horizontal. Then the currently open presentations can be identified intelligently and arranged in a horizontal tile. 3. According to personal habits, we can also select Vertical Text Box, or Cascade.4. If we want....

    Presentation views
    How to create a flowchart in Word

    How to create a flowchart in Word

    03:14

    How to create a flowchart in Word

    We often need to paint various Flowcharts in the office routine. In WPS Writer, we can make flowcharts easily with the Insert Shapes function.There are many kinds of flowcharts. Today, we will give an example to illustrate better. Step one, insert a drawing canvas.Click Insert, then click Shapes and select New Drawing Canvas to add one.A great benefit is that we can drag the canvas directly to move the flowchart.You can drag the position of the canvas only if the canvas is set to a te....

    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 quickly update the table of contents

    How to quickly update the table of contents

    01:10

    How to quickly update the table of contents

    How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

    Writer 0.1004 views
    How to set the calculated field of the pivot table

    How to set the calculated field of the pivot table

    01:49

    How to set the calculated field of the pivot table

    We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

    Spreadsheet 0.1773 views
    Use subtotal feature to do statistic

    Use subtotal feature to do statistic

    04:35

    Use subtotal feature to do statistic

    The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....

    Spreadsheet views

    How to update only the page number in a table of contents

    1. Open the document we want to edit in WPS Writer.2. Click on the table of contents.3. Click References tab → and then click the Update TOC button.4. Now a Update Table of Contents small dialog box will pop up. Check Update page numbers only.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.

    Writer views
    Prev 123...5657 Next
    WPS Academy
    Products
    Partners