Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

marked as duplicate by random, BinaryMisfit Jan 15 '10 at 6:48

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Some of the options in this answer might work for you:… – arathorn Aug 25 '09 at 14:19

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.

share|improve this answer
But then it's a source of mistakes with the copy/edition/copy back : easy to lose cells in the process. – Gnoupi Aug 25 '09 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 '09 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 '09 at 7:33

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.

share|improve this answer

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