Excel How to Compare Sheets

“Comparison” utilities » Compare Sheets
In the Excel menu choose: D-PRO  » Comparison » Compare Sheets

  1. Peer to Peer Comparison.
  2. Based on Column Comparison.




 
1. Peer to Peer.

  • 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.
 
2. Based on Column.

  • 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. 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.
Excel lower case
Excel Data Cleaning

Copyright © 2014 - 2018 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Compare Sheets
Compare Sheets
Excel lower case
Compare Sheets
Compare Sheets

Dose For Excel
Free trial 14 days (with full functionality)
Home
HOME           PRODUCTS           EULA           SUPPORT           ABOUT US