WPS2019 workbook side-by-side comparison operation process

1. For example: The numerical summary of the worksheet (workshop summary table) in the workbook (workshop limit reimbursement card summary. You need to switch between different worksheets, which is a bit troublesome. To improve efficiency, here is a trick.

2. First, switch the title command bar to [View], and select [New Window] in the toolbar of the view, as shown in the following figure:

3. After clicking [New Window], two identical workbooks will appear [Summary of Workshop Limit Reimbursement Cards.xls1] and [Summary of Workshop Limit Reimbursement Cards.xls2].

4. In the toolbar of the [View] command, select [Side by Side Comparison], as shown in the following figure:

5. Mouse Click [Display Side by Side], and two identical workbooks [Workshop Limit Reimbursement Card Summary.xls1] and [Workshop Limit Reimbursement Card Summary.xls2] are displayed on the current screen, as shown in the following figure:

6. Select one of the workbooks [Workshop Limit Reimbursement Card Summary.xls2] with the mouse, and switch the current worksheet to [Apartment Workshop], so that two different worksheets in the workbook can be compared side by side. .

7. As long as the mouse switches between two different worksheets, we can edit the data in the table very quickly, which can greatly improve our data retrieval efficiency. If you don’t believe it, you can try it.

The above is the detailed content of WPS2019 workbook side-by-side comparison operation process. For more information, please follow other related articles on the PHP Chinese website!