Excel 2007/2010
Home Up TN 2010 Outloook 2007 Outlook 2010 Word 2007 Word 2010 PPT 2007 PPT 2010 Windows 7 Vista Access 2007 About Us


Comparing Two Workbooks/Sheets Side by Side

It is possible to open two workbooks/sheets and do a side-by-side comparison by using the View Side by Side button.

To compare two workbooks/sheets side by side:
Open the two workbooks
Display the two same worksheets

Go to View tab / Windows group / View Side by Side button
The Synchronous Scrolling setting is the default

Comparing two worksheet windows side by side.
 
Compare the date from the two worksheet windows side by  side.

Click the Reset Window Position button if you want to reset the window positions of the two workbooks after resizing one or both windows.

Resized the window as needed.

Click the View Side by Side button in the Window group again Excel returns to Normal view.
 


Created:  July 05, 2012

Sr. Arlene Callahan
Training Manager
Rivier University
Nashua, NH 03060

E-mail: acallahan@rivier.edu