Compare Sheets In Excel
Comparing Excel sheets will take long time if doing it manually, especially if you have huge sheets with a lot of columns and rows. You can compare sheets using 2 methods, peer to peer comparison or based on column comparison. Dose for Excel’s Compare Sheets utility makes the comparison between Excel sheets much easier than ever.
- Click DOSE » Compare Sheets
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-pane.png)
- Peer to Peer Comparison
- Click on DOSE PRO » Compare Sheets.
- Check Peer to Peer option,
- Click on browse button to select the Old sheet if it is on external workbook or select from drop down list if old sheet is in current workbook.
- Click on browse button to select the New sheet if it is on external workbook or select from drop down list if new sheet is in current workbook.
- Compare old and new sheets by peer to peer comparison will compare them row by row (ex: old sheet (row number 1) is compared to new sheet (row number 1)) and so on.
- Options to set colors for update, new, removed rows and cells.
- Option to insert comments in the new sheet to show the old value of the updated cells.
- Option to show the Old / Updated data in the same cell.
- Ability to compare between 2 external worksheets or current sheet in your workbook.
- And then click Apply. See screenshots.
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-peer-test1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-peer-test2.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/arrow-direction-right-39651-1024x5121-1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-peer-result1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-peer-result2.png)
- Based on Column Comparison
- Click on DOSE PRO » Compare Sheets.
- Check Based on Column option,
- Click on browse button to select the Old sheet if it is on external workbook or select from drop down list if old sheet is in current workbook.
- Click on browse button to select the New sheet if it is on external workbook or select from drop down list if new sheet is in current workbook.
- Compare old and new sheets based on column, the comparison will look for each cell in the old sheet and look it up in the new sheet and vice versa then comparing the row data to show the changes. In below example, is based on column (Name).
- Options to set colors for update, new, removed rows and cells.
- Option to insert comments in the new sheet to show the old value of the updated cells.
- Option to show the Old / Updated data in the same cell.
- Ability to compare between 2 external worksheets or current sheet in your workbook.
- And then click Apply. See screenshots.
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-based-test1-1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-based-result1-1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/arrow-direction-right-39651-1024x5121-1.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-based-test2.png)
![Excel Compare Sheets](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-compare-sheets-based-result2.png)
More Features:
Excel Remove All Macros
Remove All Macros From Excel Workbooks Delete Macros, User Forms, VBA modules, etc. from Excel…
Excel Work Area View
Excel Work Area If you have many data in Excel sheet cells, and want to…
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…
Excel Split
In Excel, split the first and last word, or divide them by a delimiter or…
Excel Merge
How to Merge Cells in Excel Merging cells is a common practice when working with…
Compare Lists in Excel
Compare Lists in Excel If you ever want to compare lists by looking up for…