Excel 2007: How to view two worksheets side-by-side Excel 2007中如何查看两个工作端侧

There are many times when you need to compare two workbooks in Excel.有很多次，当你需要比较两个工作簿在Excel中。 Flipping back and forth between the two is a major pain.两者之间来回翻转，是一个重大的痛苦。 Here is how to view two workbooks side-by-side in Excel 2007.下面是如何看待两个工作簿在Excel 2007中端。

1. Open the two workbooks you want to compare打开你要比较的两个工作簿
2. Click on the View tab at the top of the page在页面顶部点击“ 查看 ”选项卡
3. On the Window group under the View tab click the View Side by Side button.上的“ 查看 ”选项卡下单击“ 窗口”组查看边侧键 。 If you only have two workbooks open, Excel will automatically choose these two workbooks.如果你只需要打开两个工作簿，Excel会自动选择这两个工作簿。 If you have more than two workbooks open, a dialog box will open so that you can choose which two workbooks to compare.如果你有两个以上工作簿打开时，会打开一个对话框，你可以选择比较这两个工作簿。

Side by Side button通过边侧的按钮

From here you have some more options:从这里，你有更多的选择：

You can click Arrange All to view the two workbooks horizontally or vertically.你可以单击“ 全部重排 ，以查看两个工作簿水平或垂直。

Arrange All button安排所有的按钮

You can also turn Synchronous Scrolling on or off. 同步滚动，您还可以打开或关闭。

Synchronous Scrolling button同步滚动按钮