Use MATCH function to search location information

The MATCH function can return information about the location of the lookup content based on the lookup value. Take this spreadsheet as an example. We want to find the location of the column where the contact Andrew is located. Then we can use the MATCH function. The syntax structure of MATCH function is: MATCH(lookup_value,lookup_array,match_type)In this table, we need to find out which row Andrew is located in column A by his name in cell D3. Click the Formulas tab and the Insert Func....

How to use the document comparison function

After modifying the document, we can compare it with the original document and generate the revised document if we want to view the modification trace. Next, I will show you how to use the comparison function through a case. Take "Document 2" as an example. Click the Review tab and the Compare drop-down button, and choose Compare. Then, a dialog box will pop up. In the Original document box, select "Document 1". In the Revised document box, select "Document 2". In the Label changes wit....

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

How can we insert endnotes for Documents

Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....

How can we add footnotes to a Document

Footnotes usually appear at the bottom of the page. These are comments on certain content. When editing text, we often need to use footnotes to supplement the specific text. For all, easy our work with WPS Office Writer. So how can we insert a footnote to the document? · Step 1Place the mouse cursor where you want to insert the footnote. Click the References tab, then click Settings. And finally click footnote/ (and)endnote. · Step 2Set the Location according to our needs in the Footno....

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

Quickly locate the name of the row and column where the cell is located

We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....

How to compress PDF files

We use powerful PDF in our daily life nearly every day.In our daily work, we may have encountered large PDF files. It not only affects the transmission speed but also takes up too much space. Using the compression feature of WPS Premium can quickly help you to solve this problem.Take this file as an example.1. Click the Tools tab.2. Then click Compress.3. Now a dialog box will pop up. Here, we can choose the compression level. This will determine the image quality of the compressed fil....