Home >Topics >excel >How to compare the differences between two excel contents?

How to compare the differences between two excel contents?

coldplay.xixi
coldplay.xixiOriginal
2020-06-18 13:57:5024084browse

How to compare the differences between two excel contents?

How to compare the contents of two excels?

Methods to compare two excel contents with different contents:

1. Find the Microsoft Office tool - Spreadsheet Compare 2016 software in the start menu and open the software .

How to compare the differences between two excel contents?

2. Click the "Compare Files" button in the upper left corner to open the dialog box, click the browse button to open the files to be compared respectively;

How to compare the differences between two excel contents?

3. After opening the file, the software interface is displayed in five parts. In the upper two parts, the old file is displayed on the left and the new file is displayed on the right. The menu bar has buttons to adjust the display mode: show formuias - display formulas, resize cells to fit - cell width suitable for content display, show workbook formatting - display in original file format;

How to compare the differences between two excel contents?

4. The three columns at the bottom of the software display respectively: the left side displays the comparison items, the middle side displays the comparison results, and the right side displays the statistical data of the differences;

How to compare the differences between two excel contents?

5. Click to select in the displayed results, and the corresponding cells of the two files will be highlighted for easy viewing;

How to compare the differences between two excel contents?

6. Displayed in the lower right corner of the software Statistical histogram, specific data will be displayed when the mouse points to each column;

How to compare the differences between two excel contents?

7. The comparison results can be exported to an excel file;

How to compare the differences between two excel contents?

8. The exported excel file is displayed in two worksheets, one is the result list and the other is the comparison option.

How to compare the differences between two excel contents?

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to compare the differences between two excel contents?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn