I have two files. Each has a large sheet with the same name but the data has several differences in some cell values. How can I compare and highlight the differences quickly without reviewing cell by cell?
- Open one of the files
- Menu item (depending on installed version)
-
Edit-Track changes-Compare document
or -
Edit-Compare document - Select other file to compare
1 Like