Ask Your Question
0

how to compare two sheets for differences

asked 2021-04-19 16:37:16 +0200

FredPenn gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2021-04-19 16:51:58 +0200

keme gravatar image

updated 2021-04-19 17:14:03 +0200

  • 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
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-04-19 16:37:16 +0200

Seen: 25 times

Last updated: Apr 19