# Compare two sheets for differences in WPS Office Excel

January 21, 2022
3.5K Views
0

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

### Are you ready to master how to find differences between two sheets in WPS Office Excel? After learning this WPS free tutorial, you will be advanced from a beginner in WPS Spreadsheet.

Sometimes we need to compare two worksheets and find out the differences between them but youll feel dizzy to compare each item one by one. At this point, the View Side by Side and Manage Duplicates function can help a lot.

### Let’s have a try step by step.

Here we take two performance appraisal sheets (January and February)for example. These two sheets are inconsistent in the name order and appraisal results.

January

February

## · View side by side

For convenience, we want to view these two sheets side by side.

1. Head to the View tab > New Window > View Side by Side.

2. Then the two sheets are arranged side by side and we can check them respectively.

Note that the new window is linked to the original window, which means when you edit one of them, the other will be edited synchronously. When you finished comparison, you can close either of them.

## · Highlight unique values

1. Navigate to the Data tab  > Manage Duplicates > Highlight unique values. Then the Mark unique data dialog pops up.

2. Click Two worksheets, and check the worksheets that you need to compare. (You can also compare sheets from different workbooks by clicking Add files.)

In this example, we check January and February.

3. In the Comparison Typp drop-down list, there are two options: Whole Line Comparison and Compare Cells in Same Position.

Whole Line Comparison: to take a row as one unit for comparison

Compare Cells in Same Position: to take a cell as one unit for comparison

In this example, we need to choose Whole Line Comparison.

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

Then the different rows are highlighted with the color we chose. With these steps, we are able to find and compare differences between two sheets quickly and freely. Did you get it?

## · Terms Explanation

### 1. What is Manage Duplicates?

The Manage Duplicates function is to quickly highlight or fetch duplicates or unique values. With this function, we can avoid comparing data or fetching 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.