If you have workbooks with data that needs to be compared then Microsoft Excel has an excellent feature that helps you to compare two workbooks side by side. Excel arranges the two files horizontally. Perform the following steps to compare workbooks:
1. Open the workbooks that need to be compared.
2. With the focus on the workbook that needs to be compared, click View tab and then click View Side by Side. If you have more than two workbooks opened then you will see a dialog box with the names of the workbooks. Click on the workbook that needs to be compared and then click OK.
3. By default, Synchronous Scrolling button is enabled. This makes the two workbooks to scroll simultaneously. You may also disable the Synchronous Scrolling to disable the simultaneous scrolling of the workbooks.
4. If you had changed the height and width of the workbooks then you may click on the Reset Window Position button in the View tab to align the workbooks horizontally and also with equal size.
5. The last part is saving the layout of the workbooks for future reference. Click the Save Workspace button which is in View tab.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
