You can also compare the data in worksheets in different workbooks. To do that, open the workbooks containing the worksheets you want to view. Then, click the Window menu.