260 results for how to cross reference two lists in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to view two documents side by side in WPS Writer00:54
How to view two documents side by side in WPS Writer
No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....
Use the cross-reference function to quickly jump01:19
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 ....
Use the ROW function in WPS Spreadsheets for row numbering03:03
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....
Use VLOOKUP function to create dynamic charts03:44
Use VLOOKUP function to create dynamic charts
In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....
The INDEX function03:50
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 compare two sets of data in WPS Office Excel
In this article, you will know how to compare two sets of data in WPS Office Excel with simple steps as following: In our daily work, we often need to compare two sets of data, but it makes us dizzy to switch back and forth. So how can we compare two sets of data quickly and easily? Let's have a try step by step. Here we take a performance appraisal table of employees as an example. We want to know how they performed and whether they made progress in these two months. We can use th....
How to compare two excel sheets and highlight differences
In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows. How to quickly compare two excel sheets for differences in values? You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.For example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row b....
How to draw the different types of text box01:29
How to draw the different types of text box
If we want to insert text anywhere in the document, we can use a text box to finish it. The text box is divided into two types: horizontal text box and vertical text box. · Horizontal Text Box:Get into the Insert tab, click the Text Box drop-down button and choose Horizontal Text Box. When we return to the editing page, we will find that the cursor has turned into a cross shape. Then we can draw the text box where we want to insert the text. If we enter too much text beyond the visible....