Comaring Two Workbook

To compare two sheets from the same workbook, choose "Window->New Window" and then the side-by-side comparison should work.

Also use Window --> Arrange -->Select(Horizontal,Vertical,Tiled,Cascade) to compare more easily.