Use the cross-reference function to quickly jump

When writing a long article, we may find the content of it may be related to each other.Take this paper as an example. The content of the first heading in the text is quoted in the summary part. It will take us a lot of time to scroll the page with the mouse to find the heading. If we use the cross-reference feature, we can quickly jump to the referenced location. First, click the place where we want to use the cross-reference feature. Click the Cross-reference button in the Reference ....

How to align shapes in WPS Presentation

You will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint.Learning to align the shapes in WPS Presentation can make the layout easier. So how to use the function of Align?Select the shapes to be aligned, click the Drawing Tool tab, and then click the Align button. In the Align drop-down menu, you can set the alignment as needed.Note: same alignment settings show different effects with different reference objects. Here are three different wa....

Use the ROW function in WPS Spreadsheets for row numbering

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....

Customize the TOC level

To facilitate reading, we will set the table of contents for the headings of contents in the long document. Do you know how to set the TOC level correctly? Take this document as an example. If we want to generate the table of contents, click Reference and then click Table of Contents. A blank table of contents is inserted, which is not what we want.GIf We need to set the table of contents for headings in the article. First, select the first bold heading in the article, click the Refere....

How can we use RANK function

RANK function is a statistical function that can quickly calculate the rank of a number in a list of numbers. Taking this sales table as an example, how do we rank the sales volume in the first quarter? First, we can place the cursor in cell F3, click the Formulas tab, and Insert Function button to find RANK function. At this time, the Function Arguments dialog box will pop up.Number is the number for which you want to find the rank. Ref is an array of, or a reference to, a list of num....

Use formula to set the conditional formatting

Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the New Rule option. In the pop-up dialog, we choose the Use a formula to determine which cells to format option.In the Format only cells with edit box, enter the formula "=$C2="Finished" ". The absolute reference has been added to the co....

The INDEX function

The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....

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", ....