A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Excel 2007: How to view two worksheets side-by-side

There are many times when you need to compare two workbooks in 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.

  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. 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

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

Arrange All button

You can also turn Synchronous Scrolling on or off.

Synchronous Scrolling button

Synchronous Scrolling button

VN:F [1.9.6_1107]
Rate this Post
Rating: 5.0/5 (2 votes cast)
Excel 2007: How to view two worksheets side-by-side, 5.0 out of 5 based on 2 ratings
Translate this post

Comments are closed.