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

        1229 results for how to update cross references in word

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

        1229 results for how to update cross references in word

        How to set up paging or cross-page printing in WPS Writer

        How to set up paging or cross-page printing in WPS Writer

        01:47

        How to set up paging or cross-page printing in WPS Writer

        The system prints all the pages by default when printing a document. But what if we only want to print part of the pages in the document? Today we're going to share with you two solutions.l Method 1. Select the print range.Take this document as an example. If we only need to print pages 1, 4, 5, and 9, we can click the Print button in the upper left corner or press CTRL+ P to pop up the dialog box. At Page ranges, enter 1, 4, 5, 9, and insert commas to separate them from each other....

        Writer 9.3K 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 16.6K 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 24.1K 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 17.4K views
        Why error message #NULL! occurs and how to solve it

        Why error message #NULL! occurs and how to solve it

        01:51

        Why error message #NULL! occurs and how to solve it

        You may not know what to do if the error message "#NULL!" occurs when carrying out calculations in a table. Today, I'll talk about why the error message #NULL! occurs and how to solve it. In general, the error message "#NULL!" is caused by the lack of the reference operator in references, resulting in an empty range of references. · The formula references continuous cell range without the correct reference operator.Take this table as an example. If we want to sum up the company'....

        Spreadsheet 6.4K views
        Why error message #REF! occurs and how to solve it

        Why error message #REF! occurs and how to solve it

        03:18

        Why error message #REF! occurs and how to solve it

        The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

        Spreadsheet 6.5K views

        How to Make References to Other Files in Excel with Formula

        When calculating data in Excel, you may often find yourself in a situation when you need to pull data from another worksheet or even from a different Excel file. Can you do that? Of course, you can. You just need to create a link between the worksheets (within the same workbook or in different workbooks) by using what is called an external cell reference or a link. External reference in Excel is a reference to a cell or a range of cells outside the current worksheet. The main benefit ....

        xls Spreadsheet 8.4K views
        Get started with functions and formulas

        Get started with functions and formulas

        10:29

        Get started with functions and formulas

        1. Reviewed the steps to insert functions in the table, there are 3 entrances to insert functions. You do not need to remember each function, just enter the first few letters, and the system will generate an automatic association.2. shared the 3 types of formula references, namely relative, absolute and mixed references.3. shared the function of how to reference data across worksheets or workbooks.

        Spreadsheet 12.0K views
        Prev 1 2 3 ... 153 154 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