How do I compare two versions of an excel document?

  • Thread starter Thread starter fiona
  • Start date Start date
F

fiona

I have been given an updated version of a spreadsheet and I have the original
on my computer can I compare the two so I can see what has been changed
without going through line by line
 
It depends on what you're looking for.

This may help if you want to compare two worksheets and do a cell by cell
comparison (A1 with A1, x99 with x99, ...)

http://www.cpearson.com/excel/whatsnew.aspx
look for compare.xla

======
But as soon as a row/column is inserted or deleted, then the results go to heck.

If you're only looking at values in two worksheets, you may be able to save the
worksheets as comma separated and then use another program to compare these two
..CSV files.

MSWord has this ability. And there are free versions of file comparisons that
you can find via google.
 
Back
Top