Sep 21 2010

View Two Workbooks at the Same Time

Excel has a built-in way to be able to view two workbooks at the same time side by side. This can be useful when comparing similar values or graphs between workbooks without having to flip back and forth or without copying data from one workbook to the other.

[ad#in-post-ad]

Steps to Comparing Workbooks Side-by-Side

1. Open both workbooks you want to compare side by side.

2. Select Window–>Compare Side by Side with [workbook2]

3. There are two options for viewing the data of the two workbooks you are now comparing

  • Click “Synchronous Scrolling” to scroll through both documents at the same time. Uncheck for independent scrolling.
  • You can also reset the scrolling position to the starting position by clicking the button “Reset Window Position”.

4. When you are finished with your comparison, click Close Side by Side to return to the normal worksheet view.


Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          

2 Comments on this post

Trackbacks

  1. used tires said:

    This is definitely an awesome built in function in excel, and this would be an even better function if you have the luxury of having a fairly large sized LCD Monitor as well as the ability to run a higher resolution! :)

    Till then,

    Jean

    October 5th, 2010 at 7:25 pm
  2. Underfloor heating mats said:

    there is usually two solutions relying upon the information which needs to be in contrast. if little, copy data from 2nd sheet in to the very first sheet. make sure the formatting is very same, coz when u copy paste, it will need to glimpse exactly the same as inside the authentic sheet. this way u can compare.

    December 4th, 2010 at 10:52 am

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives