Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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, Diago 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: superuser.com/questions/18626/… –  arathorn Aug 25 '09 at 14:19

4 Answers 4

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

I'm not sure what sort of comparison you are after, but I have used the macro from here to compare two worksheets before. It shows the differences in a new sheet. Might be what your after.

share|improve this answer
    
I actually want to compare two sheets side by side and look at differences.. –  Shaharyar Aug 25 '09 at 12:52

I find Cols answer quite suitable for the purpose.
If you need to script for checking differences automatically
you can use the methods described in this question.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.