1

Possible Duplicate:
Compare between Excel worksheets

The title actually explains it all.

I would like to be able to compare two Excel Sheets in one Excel document.

Comparing two different files can be accomplished by going to the "View Tab" and clicking Arrange All / Split.

But how can I compare two excel sheets in the same document?

Help is very appreciated!

Thanks SuperUsers ;p

1

2 Answers 2

1

I'm not sure if that is possible but as a quick and dirty fix you could do a right click copy sheet to a new excel file and do the comparison against that.

3
  • But then it's a source of mistakes with the copy/edition/copy back : easy to lose cells in the process.
    – Gnoupi
    Aug 25, 2009 at 13:42
  • I think this is a good scheme if you cannot compare two sheets within a XLS. The entire sheet will get copied out to another XLS -- this is not a cut-and-paste operation and I doubt if you will loose any cells.
    – nik
    Aug 26, 2009 at 1:48
  • If you wanted to be sure you were working on the right version you could move the sheet instead then move it back when you're done with your comparison.
    – Col
    Aug 26, 2009 at 7:33
1

You can open the same workbook twice, the second time as Read-Only. Then you can compare them side-by-side on the screen, just like two different workbooks.

This way, you will never lose data due to copy-and-paste errors, or forgetting to put any changes back in the proper workbook.

Not the answer you're looking for? Browse other questions tagged .