Home  >  Article  >  Topics  >  How to quickly compare the differences between two excel sheets?

How to quickly compare the differences between two excel sheets?

coldplay.xixi
coldplay.xixiOriginal
2020-06-15 09:57:3115180browse

How to quickly compare the differences between two excel sheets?

#How to quickly compare the differences between two excel sheets?

Quickly compare different methods in two excel tables:

1. Let’s take the two tables in the figure below as an example. It is difficult to find that these two tables are full of numbers. If you look for the difference with the naked eye, it is very easy to make mistakes;

How to quickly compare the differences between two excel sheets?

2. At this time, we can change the first table Select all the numerical areas, then right-click "Copy", as shown below...

How to quickly compare the differences between two excel sheets?

3. After copying, click the first cell of the second table, Then right-click the mouse again and select "Paste Special" - "Paste Special";

How to quickly compare the differences between two excel sheets?

4. Then the Paste Special dialog box will pop up, we check Click "Subtract" in the operation on the left side of the dialog box, and then click OK to close the dialog box;

How to quickly compare the differences between two excel sheets?

5. Return to the workbook, and we will find the second table The data has changed. The cells showing 0 indicate that the data are the same, while other areas indicate that there are differences in the data, as shown in the figure...

How to quickly compare the differences between two excel sheets?

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to quickly compare the differences between two excel sheets?. 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