Show All

Compare workbooks side by side

1. Open the workbooks you want to compare side by side.
2. On the Window menu, click Compare Side by Side with.
3. On the Compare Side by Side toolbar, do any of the following:
   • If you want to scroll through the workbooks at the same time, click Synchronous Scrolling .
   • If you want to reset the workbook windows to the positions they were in when you first started comparing workbooks, click Reset Window Position .
4. Click Close Side by Side to stop comparing workbooks.

Note  If you open two workbooks, the command on the Window menu will include the filename of one of those workbooks. For example, you open "workbook1.xls" and "workbook2.xls". While viewing "workbook1.xls", the Window menu shows the command as Compare Side by Side with workbook2.xls.

Tip