Compare two excel files for differences in WPS Office Excel

January 21, 2022
656 Views 0

Welcome to WPS Official Academy to check the contents of compare two excel files for differences in WPS Office Excel.

 

We often need to compare the data from two different excel files, but it would be troublesome to compare each item one by one with naked eyes. So how can we compare two excel files for differences in a quick and easy way? 

Let’s have a try step by step.

 

Here we take two tables of employees performance appraisal for example. We can find the two tables are inconsistent with the name order and appraisal results.

Compare two excel files for differences in WPS Office Excel1.png January

Compare two excel files for differences in WPS Office Excel2.png February

 

Now we want to know if there was a change in employees’ performance in January and February by comparing these two excel files.


· Display two files side by side

Open the sheets that we need to compare. It’s troublesome to switch between two files, so we can display them side by side.

There are two methods.

Option 1

Navigate to the View tab and click the Arrange All drop-down button. There are three options for selection.

Compare two excel files for differences in WPS Office Excel3.gif 

Horizontal Text Box: to display two files horizontally

Compare two excel files for differences in WPS Office Excel4.png 

Vertical Text Box: to display two files vertically

Compare two excel files for differences in WPS Office Excel5.png 

Cascade: to cascade to files in one screen

Compare two excel files for differences in WPS Office Excel6.png  

In this way, you can only slide these two files respectively.

Compare two excel files for differences in WPS Office Excel7.gif 

Option 2

Navigate to the View tab and click View Side by Side.

In this way, your can check Sychronous Scrolling on the right of the View Side by Side button to scroll the two sheets at the same time or uncheck it as needed. You can also click Reset Position to reset it quickly.

Compare two excel files for differences in WPS Office Excel8.gif 

· Find the differences between two files

Come to either of these two files, and here we come to the January file.

1. Head to the Data tab, click the Manage Duplicates drop-down button and click Highlight unique values.

2. In the pop-up dialog, select Two worksheets, click Add files to add the other file. Here we add the February file. Then check these two sheets.

3. In the Comparison Type area, we can choose Whole Line Comparison and Compare Cells in Same Position.

Whole Line Comparison: to compare by row

 Compare Cells in Same Position: to compare by cell

In this example, we choose Whole Line Comparison.

4. Choose a color for highlight and click Confirm to mark.

Compare two excel files for differences in WPS Office Excel9.gif 

With these steps, you are able to compare two excel files for differences quickly and freely. Did you get it?

 

· Terms Explanation

1. What is Manage Duplicates in WPS Spreadsheet?

The Manage Duplicates function is to quickly highlight or fetch duplicates or unique values. With this function, we can avoid comparing data or fetch needed data with naked eyes, which greatly improve our work efficiency.

 

2. What is WPS Spreadsheet?

WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal basic version is free to use and it also provides abundant functions and unique features for you to explore.

 

Learn more advanced skills about comparison in WPS Spreadsheet:

The Camera in WPS Spreadsheet | WPS Academy Free Office Courses

How to compare two excel sheets side by side| WPS Academy Free Office Courses

 

In free WPS Office tutorial, we are going to compare two excel files for differences in Excel. Above are the easy and professional steps to create chart in WPS Spreadsheet, similar to Microsoft Office and are available for Windows, PC, Mac, Linux, Android, and iOS devices.

Was this helpful?