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 .

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;

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;

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;

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

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

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

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

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!